Well.. Ours is lightning fast with around 32k tickets and no mod perl(cant use mod perl if you are hosting more than 1 otrs through single instance of apache). Running on Xserve G5’s with each 2gb memory, nothing special.

Upgrading to the latest version of mysql really did the most for us, separating the database server and the web server, and editing the my.cnf to have much larger caches.  We also use FS storage for articles.

At first I didn’t like the idea of perl (was using deskpro) but after using OTRS for 2 years we have realized its not so bad.  The only reason I wanted PHP is because I can understand it :)

Just be thankful its not java!

-Andy


On 8/16/07 7:52 AM, "Laurent Minost" <lminost@denyall.com> wrote:

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





_______________________________________________
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/


--