1. Optimize your database calls: http://www.mysql.com/doc/en/MySQL_Optimisation.html
2. Buy bigger servers. 3. Optimize your application. 4. Upgrade to ver 4.x to take advantage of query caching. I apologize for the general answer, but optimization is _very_ specific and without detailed information on your set up thats about all anyone can provide. If you are reason Scott Helms On Fri, 2003-08-01 at 15:17, Daniel Negron/KBE wrote: > I have an osCommerce Site along with another Dating site on a completely > different server. on the oscommerce site I have 1200 products and the > server queries the records very slowwly. I have enabled gzip compression > to try and speed this up. Only very slightly has the oscommerce site been > sped up. The dating site has 11000 records in it and the same thing has > happened and I am wondering what I can do to speed up the queries that are > made to each site. > > Any suggestions ? > > TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]