Hi all, While searching tickets from search module of otrs, it takes hell lotta time to give results...finally ending up with "Internal Server error". Pullin the SQL script that lists distinct tickets, from code, and running it directly in MYSQL client also takes hell lot of time, processing going into loop. I looked at the count of following huge tables..ticket,ticket_history, article...all shows records > 500000+. Deleting 200000+ rows does bring things back to normal. Searching on various MYSQL related forums i did get a clue that mysql cannot handle joins of huge tables, as is the case with me. Is there anyway out of this situation. Please Suggest. Thanks. Aleem B. Bollywood, fun, friendship, sports and more. You name it, we have it on http://in.promos.yahoo.com/groups/bestofyahoo/