empty cart Posted February 20, 2007 Posted February 20, 2007 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
Guest Posted February 21, 2007 Posted February 21, 2007 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.