josh1r Posted May 4, 2005 Share Posted May 4, 2005 I have a site that has over 30,000 products and a few hundred cats and subcats and it's getting quite slow. I've had to remove some of the products in order to make it quicker. My question is this: would the site be faster if there were the same # of products but less categories? Just as an example, a site with 50,000 items and 300 categories will be quite slow, but if put all of those items in just 1 or 2 categories would it be much faster? Thanks! p.s. I already turned off category counts Link to comment Share on other sites More sharing options...
Guest Posted May 4, 2005 Share Posted May 4, 2005 That catalog should not present significant performance issues if a few basic measures are implemented. First, make sure all the cache settings are functional and that the catalog is creating the cache files. Once you do that make sure that the database has the proper indexes. Then, look into optimizing the code for speed. The most difference with categories versus products will come with the type and number of contributions installed. Some will be extremely hard on categories (i.e. - Simple Template System) and others will be extremely hard on products. Bobby Link to comment Share on other sites More sharing options...
josh1r Posted May 4, 2005 Author Share Posted May 4, 2005 Thanks Bobby. I'll look into your suggestions this evening. I've definately noticed that when I start crossing over 40k and definately by 50k that the site slows down incredibly. Some pages took 15 seconds and ran 150+ queries... Thanks again! Link to comment Share on other sites More sharing options...
ukgoods Posted May 11, 2005 Share Posted May 11, 2005 That catalog should not present significant performance issues if a few basic measures are implemented. First, make sure all the cache settings are functional and that the catalog is creating the cache files. Once you do that make sure that the database has the proper indexes. Then, look into optimizing the code for speed. The most difference with categories versus products will come with the type and number of contributions installed. Some will be extremely hard on categories (i.e. - Simple Template System) and others will be extremely hard on products. Bobby <{POST_SNAPBACK}> Bobby, I have a store with about 240 products. What should the proper indexes be for this store? Thanks, Donna Gordon UKGoods.com Link to comment Share on other sites More sharing options...
Guest Posted May 11, 2005 Share Posted May 11, 2005 Donna, It shouldn't need further attention with 240 products but it never hurts to have proper indexes :) As a general rule, if the column type is INT and is used as an ID in another table it should be indexed. This is a very broad stroke but is the best I can do here since the variety of contributions is so great. My usual practice is to install the osC-Explain contribution which I coded just for this purpose. Part of the data collected is the recommendations of the MySQL server as to indexes on tables. Bobby Link to comment Share on other sites More sharing options...
ukgoods Posted May 11, 2005 Share Posted May 11, 2005 Donna, It shouldn't need further attention with 240 products but it never hurts to have proper indexes :) As a general rule, if the column type is INT and is used as an ID in another table it should be indexed. This is a very broad stroke but is the best I can do here since the variety of contributions is so great. My usual practice is to install the osC-Explain contribution which I coded just for this purpose. Part of the data collected is the recommendations of the MySQL server as to indexes on tables. Bobby <{POST_SNAPBACK}> Thanks Bobby! You rule!!!!!!! Donna Link to comment Share on other sites More sharing options...
Guest Posted May 11, 2005 Share Posted May 11, 2005 Thanks Bobby! You rule!!!!!!! ...only in my own mind :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.