tokyoNH Posted October 29, 2008 Share Posted October 29, 2008 Hello, I have searched the forums and found some threads that deal with this, but nothing in great detail. I am in the process of opening up a Manga / Anime shop online. I loaded about 1/3 of my library last night (7,000 of 20,000 items) and am worried that this is too much data for PrestaShop. There are about 2,000 categories I have uploaded and I think the issue is the organization of the tables. I have not even uploaded images yet...I am going to try indexing the tables (I don't know if that is possible in mySQL as I am a MS SQL developer) - but I am hoping that will speed things up. Right now, even a category with ZERO products takes 12 seconds to load. When I was testing with 2 products, performance was great. It was 1/250 second to load a category. As you can see, it is now 480x slower.Anyone have tips on performance updates for a large database? Anyone with success over 10,000 products? Do you know if indexing the product and category tables will improve this speed?Also, do any of the Presta developers know if 1.1 will address speed issues?Thank you for your help.Ray Larosehttp://tokyonh.comhttp://tokyonh.com/tenpo (shop) Link to comment Share on other sites More sharing options...
Paul C Posted October 29, 2008 Share Posted October 29, 2008 Had a quick peek, and I think it's the number of categories rather than the number of products, but I could be wrong! The categories navigation is all but unusable with that many, and remember that you're listing them all on every page - that's going to slow things down on its own, never mind taking into account database access timing.If it was me, and I HAD to have that many categories, then I would be looking at doing some caching, somewhere in there....hard to say where to start without examining what it's doing closely.Paul Link to comment Share on other sites More sharing options...
tokyoNH Posted October 29, 2008 Author Share Posted October 29, 2008 Thank you Paul. I'll start seeing what I can do about the categories. I hate having that many, but manga is grouped by series, and each series has from 1 to 100 books in it. I'll see if shaving that down helps at all. I appreciate your reply!Ray Link to comment Share on other sites More sharing options...
tokyoNH Posted October 29, 2008 Author Share Posted October 29, 2008 OK, did a quick test and removed the category module. Now takes a second to load the main page, and about 3 seconds to load a page showing "other products in this category"So, you are right. The server hits the category table for EVERY page. I need to cache this. Link to comment Share on other sites More sharing options...
daYmo Posted November 12, 2008 Share Posted November 12, 2008 Hi tokyoNH,I also have something like a hundred of categories/subcatgeroies and about 3000 products.It's very very slow...Did you speed up your system yourself ? What did you do ?Thanks coz I can't wait for for PS 1.1 ! Link to comment Share on other sites More sharing options...
Damien Metzger Posted November 12, 2008 Share Posted November 12, 2008 You can try the new category module from the 1.1 beta for your 1.0.I don't know if it will work, but it's worth the attempt. Link to comment Share on other sites More sharing options...
daYmo Posted November 12, 2008 Share Posted November 12, 2008 Thanks Damien,but I already did that I'm at the moment optimizing everything, etc. That's why I also request for a feature that would consist of being able to configure another server address for media content (if you put media content onto another server, performance are highly improved).I'll let you know what improvement are important later Link to comment Share on other sites More sharing options...
tokyoNH Posted November 12, 2008 Author Share Posted November 12, 2008 Thanks Damien,but I already did that I'm at the moment optimizing everything, etc. That's why I also request for a feature that would consist of being able to configure another server address for media content (if you put media content onto another server, performance are highly improved).I'll let you know what improvement are important later That would be great! To host the images on one server and the data & scripts on another! Link to comment Share on other sites More sharing options...
daYmo Posted November 12, 2008 Share Posted November 12, 2008 Yep that would be good... I already submit a request feature. Link to comment Share on other sites More sharing options...
Recommended Posts