Hi Patric,

Thks for your reply.

I'm already using an optimize script in cron each night for all OTRS tables since OPTIMIZE seems not being done in OTRS source code when DELETE are used through the interface so tables are already up to date.
Problem seems not being on the MySQL side since MySQL server is well tuned ( home-made tuning and through tuning-primer.sh advices ) and answering pretty well through PHP and other scripts.

We don't try to use deflate/gzip modules since we are basically using OTRS on our Lan at the moment and I'm not pretty sure if it would be a thing that will increase performance.

BR,

Laurent


Le jeudi 16 août 2007 à 11:16 +0200, Patric a écrit : 
Hi Laurent,

You can try to optimize your database, that made a huge difference for me.
AFAIK the command would be :

	mysqlcheck -o -B otrs_database

You can also look into running mod_deflate, which will also give you a 
bit more speed.

HTH
Patric


Laurent Minost wrote:
> Hi,
> 
> Also using OTRS for a while now and I can tell that's the big complaint 
> I can also have about OTRS. I'm totally agree with Bc. Radek Krejca.
> 
> We're already using mod_perl but OTRS is still too slow. Response times 
> are very high for a proper everyday usage.
> I'm also very sad that PHP hasn't been chosed for this software.
> 
> Any way to improve response times of OTRS would be very much appreciate.
> 
> BR,
> 
> Laurent