[otrs] MYSQL slows/crashes for large ticket base.

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,

[otrs] MYSQL slows/crashes for large ticket base.

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 ti