Thanks a lot guys.
Haydies:
>Just out of wondering, are you using PHP and if so do you use mysql_pconnect >rather then mysql_connect because that would really speed things up.....
I tired pconnect before but it didn't help but using up all the available memory. It speeds up things until the disks started swapping, which happened in a few hours after the server was up and running.
Gabriel:
Gabriel,
You can also create a small RAM disk and put all of the PHP scripts and images on that drive. It will speed things up by 30%-50%. And you're right about "pconnect". It doesn't speed things up. There are PHP debuggers available that have a profiler that will show you which of your PHP functions are slow. It could be only 1 or two functions that need optimizing. Also I insist on putting a LIMIT 100 or LIMIT 25 on my web queries to reduce the number of rows returned. This should speed things up quite a bit.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
