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/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/
