Theodorb Posted July 24, 2003 Posted July 24, 2003 My Customer now has 60,000 item in his cart and it is slowing down dramtically. I have turned off the category count. Are there any indexes I can add to the DB to speed up processing. You can see the cart here http://www.mbmintl.com/oscommerce/catalog/ This is a highly modified cart and is LIVE please don't add test customers. TY Theo Share your knowlege and you learn even more !
Guest Posted July 24, 2003 Posted July 24, 2003 Loading time results for: http://www.mbmintl.com/oscommerce/catalog/ Loading test content results Number of graphics/scripts: 105 Total graphics size: 0 bytes Total HTML size: 64896 bytes Total page size: 64896 bytes Load time by modem speed Modem speed: Download time: 14.4k 39.24 seconds 28.8k 21.2 seconds 56k 12.36 seconds ISDN (128k) 7.23 seconds T1 (1.44 MB) 3.54 seconds Warning!: Your loading time is not bad... However, a top performing web site will load under 14 seconds at 28.8k. The_Bear
Daemonj Posted July 24, 2003 Posted July 24, 2003 This thread can probably assist you with the indexes. Be sure to also optimize all of the tables after addng the indexes. Do you have caching enabled? Do you have GZip compression enabled? If so, what setting are you using? Is this a shared or dedicated server? What are the specs? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
dukedl Posted July 24, 2003 Posted July 24, 2003 could you please tell me, which contribution did you use to show your categories and some of the categories on the main page at the bottom? thank you ________________________________________ osCommerce 2.2 Milestone 2, Win2k pro, Apache/1.3.22 ,mysql 3.23.42-nt,PHP Version 4.3.2
Guest Posted July 24, 2003 Posted July 24, 2003 My Customer now has 60,000 item in his cart and it is slowing down dramtically. I have turned off the category count. Are there any indexes I can add to the DB to speed up processing. Believe it or not, you are the man I am looking for! Could you please have a look at: http://www.oscommerce.com/forums/viewtopic.php?t=51746 and see if that helps with performance? P.S. Despite the dramatic warning you can install it alongside an existing cart, it will unpack two directories catalog_ori and catalog_new and not touch yuor existing directory. The warning is there to prevent ppl from overwriting their cart with the new scripts. Best thing would be to load your product data on an offline test box if you have one available to get fair results ( No other operations interfering with the tests, but it is possible to test on the same box.) Cheers, Rob
HyperJack Posted July 24, 2003 Posted July 24, 2003 could you please tell me, which contribution did you use to show your categories and some of the categories on the main page at the bottom? thank you http://www.oscommerce.com/community/contributions,580
Theodorb Posted July 29, 2003 Author Posted July 29, 2003 This thread can probably assist you with the indexes. Be sure to also optimize all of the tables after addng the indexes. Do you have caching enabled? Do you have GZip compression enabled? If so, what setting are you using? Is this a shared or dedicated server? What are the specs? Sorry for not getting back to you quickly. Thank you for those indexes, I will add them and let you know if I see any performance improvements. I am on a shared server, and I have gzip enabled at level 5. I am not using caching at this time. TY Theo Share your knowlege and you learn even more !
Theodorb Posted July 29, 2003 Author Posted July 29, 2003 could you please tell me, which contribution did you use to show your categories and some of the categories on the main page at the bottom? thank you http://www.oscommerce.com/community/contributions,580 Thank you for that link, I will be having a look at that document and see what indexs are relavent. TY Theo Share your knowlege and you learn even more !
Daemonj Posted July 29, 2003 Posted July 29, 2003 Just to let you know, I did not find the document to be of much use. Regarding GZip compression, you should have it set no higher than 2, especially on a shared server, and usually 1 is the best. Anything more and the server is working harder for not much more compression. Set it to 1 and see if that does not make a big difference. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Theodorb Posted July 30, 2003 Author Posted July 30, 2003 Just to let you know, I did not find the document to be of much use. Regarding GZip compression, you should have it set no higher than 2, especially on a shared server, and usually 1 is the best. Anything more and the server is working harder for not much more compression. Set it to 1 and see if that does not make a big difference. Daemonj Thank you for that bit of wisdom that did make a difference. I am having a problem with the Featured contribution it takes for ever to build the pull down box would you have any suggestions? TY Theo Share your knowlege and you learn even more !
Daemonj Posted July 30, 2003 Posted July 30, 2003 I suggest taking a look at the mysql calls. If you can reduce the calls and use more loops instead that would make a significant increase in speed. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Theodorb Posted July 30, 2003 Author Posted July 30, 2003 I suggest taking a look at the mysql calls. If you can reduce the calls and use more loops instead that would make a significant increase in speed. it scans the entire product table and loads all the products into an array, I am not a myql programmer so I wouldn't have clue how to do that. TY Brian Share your knowlege and you learn even more !
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.