Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysql serverside performance tuning


empty cart

Recommended Posts

Posted

hello,

 

i've read much about cache using and sql optimization here. thanks a lot for all your contribs.

 

someone of you tried to modify mysql variables like key_buffer size? if indexes are stored in memory, all queries shouldn't take that much server performance?!

 

are there any high traffic shops (many hundreds orders a day) around here to exchange experiences with stress load on osc systems?

 

thank you

Posted

instead of going and tuning each separate sql query you could deploy the advanced cache class.

http://www.oscommerce.com/community/contributions,2873

Then you place few wrapper functions for standard queries so the results are in the cache. Then you can simply pull the results and use them. So that will dramatically increase performance due to the limited number of rows returned each time from the cache. Like 1 instead of hundreds

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...