Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

mysql serverside performance tuning

empty cart

Recommended Posts



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

Link to comment
Share on other sites

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


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

Link to comment
Share on other sites


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

  • Create New...