Best way to improve performance

[Sprije]

I am currently runing Timetrex on a 550 Mhz FreeBSD 6.2 box with 300 some-odd MB RAM, and a 1.5 MB DSL connection. Timetrex runs great, but page loads are pretty slow (10-15 seconds). How might I best go about improving this performance? Would I be best off upgrading the processor, RAM, or connection speed?

Thanks for any suggestions you might have.

[shaunw]

You can try installing APC (http://pecl.php.net/package/APC), but that will only give a 10-30% performance increase.

Increasing the CPU power will be most beneficial, then ram.

[MichelleM]

Sprije -

I'm in a similar boat, as the PC I'm running TT on is maxed out in RAM and between apache, mysql and the cron job I'm doing a virtual juggling act. Other things you can try (YMMV):

Adjust your web server settings. For example, I use apache and have limited the child processes to 5.

Links:
http://www.onlamp.com/lpt/a/4494
http://httpd.apache.org/docs/2.2/misc/perf-tuning.html
http://www.intranetjournal.com/articles ... 6_05a.html

Optimize your database performance. I've gotten a crash course in MySQL server optimization and it's working.

Links:
http://forums.mysql.com/read.php?24,39066,41505
http://hackmysql.com/mysqlreportguide
http://dev.mysql.com/doc/refman/5.0/en/ ... ation.html

HTH,
Michelle