aleksa Posted January 30, 2012 Share Posted January 30, 2012 Hi all, I wonder what is the maximum number of products supported by Presta? I understand that the first set of limitations comes from the MySQL base ,but in operational terms, whichis a tunnel to cease? Is it possible to operate with millions of products? What are yours experiences? What is the max that you reached? Cheers, Aleksa Link to comment Share on other sites More sharing options...
shacker Posted January 30, 2012 Share Posted January 30, 2012 ive seen stores with more than 5000 products. The secret is using the latest version, and disable all unnecesary modules to speed up the store Link to comment Share on other sites More sharing options...
lozaria Posted January 30, 2012 Share Posted January 30, 2012 This store http://elektrobaza.com has about 10 000 products. Link to comment Share on other sites More sharing options...
tomerg3 Posted January 30, 2012 Share Posted January 30, 2012 I have worked on should with 100,000 - 200,000 products. A big part is getting a fast server, and make sure everything is optimized. 1 Link to comment Share on other sites More sharing options...
badelakshmi Posted June 24, 2012 Share Posted June 24, 2012 My site has 1,00,000 products. i imported all the products. My site is loading too slowly Please tell me what things i need to do. Thanks. Link to comment Share on other sites More sharing options...
Dh42 Posted June 24, 2012 Share Posted June 24, 2012 When you get that many products in your store the solutions aren't the same as regular stores. What are the specs of the machine it is running on? What o/s is the machine using? PHP version? Modules installed? To optimize a store with that many products you would have to be pretty through and pick everything apart with a lot of speed testing. Link to comment Share on other sites More sharing options...
tuk66 Posted June 24, 2012 Share Posted June 24, 2012 30 000 products and response is good with slight optimization. Link to comment Share on other sites More sharing options...
campeom Posted September 28, 2012 Share Posted September 28, 2012 Hello I have 145.000 products and i´ m having problems with the indexation. I can never finish it?? can any one help me please?? Thanks Link to comment Share on other sites More sharing options...
poncho_333 Posted January 29, 2013 Share Posted January 29, 2013 Hello I have 145.000 products and i´ m having problems with the indexation. I can never finish it?? can any one help me please?? Thanks Hi, Have you find solution for your indexation ? I need to include about 100.000 products ... Thanks and regards. Link to comment Share on other sites More sharing options...
campeom Posted January 29, 2013 Share Posted January 29, 2013 Hello. Yes, i found the solution making test because no body said nothing.. the problem is that the indexation process needs a big amount of memory with such a big number of products. What you have to do is to increase the memory dedicated for the php process in the php.ini. And click add products to indexation when the process stops. You will have to click more than one time... in a few number of hours. Good luck. Link to comment Share on other sites More sharing options...
poncho_333 Posted January 30, 2013 Share Posted January 30, 2013 Thanks a lot campeom !!! I gonna try your solution adding this line with big amount memory in php.ini file. So for anyone who needs it i have find this web with many tips (as the one you said) for modifing the php.ini that do prestashop running much better: http://www.prestatraining.com/12-tips-to-optimise-your-php-ini-file-for-prestashop/ Really this is a good forum !! Link to comment Share on other sites More sharing options...
Krishkv Posted January 31, 2013 Share Posted January 31, 2013 I am currently developing a website having 50,000 products! _____________ Presta Designer Link to comment Share on other sites More sharing options...
campeom Posted January 31, 2013 Share Posted January 31, 2013 (edited) Hello again Poncho. The problem you are going to find later a rendimient problem. So big amount of products made the shop slow..... I´m working hard to solve it but i dont have "the answer" so solve it completely. If you or anybody finds a solution for this matter, it will be wonderfull. I had used this information. http://www.prestasho...tashop-store-3/ My web page has today 260.000 products in Myisam DB. Which engine are you using?? How is it doing?? Thanks a lot. Oscar. Edited January 31, 2013 by campeom (see edit history) Link to comment Share on other sites More sharing options...
poncho_333 Posted January 31, 2013 Share Posted January 31, 2013 Hello Oscar, I think you speak spanish as me, but ... I am using the PS 1.5.3.1 default version engine, InnoDb, but i am testing my shop yet, ( I have not inserted all my products ... ) In other topic a moderator says this: "InnoDB uses row-locking instead of table-locking, so I think it is the superior choice. It's also selected by default when you install, so I think it is what PrestaShop recommends. You can certainly set up test sites with each database engine to compare them, but I doubt the database engine would cause features to break" you can view in this post: http://www.prestashop.com/forums/topic/86265-difference-innodb-and-myisam/ Also you can read this: (it is spanish, but your name is "Oscar" so ...): http://www.jose-aguilar.com/blog/myisam-vs-innodb/ and diference between engines in MySQL webpage: http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html ... but i do not know which one is the best option ... People say InnoDB is better for writing and MyIsam for reading ... but .. By the way, I see an engine that uses a CSV files : http://dev.mysql.com/doc/refman/5.5/en/csv-storage-engine.html May be this last option resolve all of our problems ??? (File of plain text usually are speedest). We will have to try if it is possible. Thanks and regards. Link to comment Share on other sites More sharing options...
campeom Posted January 31, 2013 Share Posted January 31, 2013 Thanks for your information. I will check. Regards from Madrid. Link to comment Share on other sites More sharing options...
aduarte Posted April 12, 2013 Share Posted April 12, 2013 im running 1.5.3.1 with 9k items and already having problems. Link to comment Share on other sites More sharing options...
BWT Posted April 25, 2013 Share Posted April 25, 2013 What about a site running on Apache shared hosting, approximately how many products can it handle before it starts to slow down? Link to comment Share on other sites More sharing options...
Peda Posted May 15, 2013 Share Posted May 15, 2013 I am using the latest version. 1.5.4.1 I have mass products imported via CSV. More then 45 000. And more then 10 000 categories+sub categories. Try disabling the following modules: Categories block New products block Tags block You will see the difference in 1.5.4.1 Link to comment Share on other sites More sharing options...
benjamin utterback Posted May 15, 2013 Share Posted May 15, 2013 I am using the latest version. 1.5.4.1 I have mass products imported via CSV. More then 45 000. And more then 10 000 categories+sub categories. Try disabling the following modules: Categories block New products block Tags block You will see the difference in 1.5.4.1 The number of categories and subcategories is impressive. What kind of hosting do you use? Link to comment Share on other sites More sharing options...
Peda Posted May 16, 2013 Share Posted May 16, 2013 (edited) The number of categories and subcategories is impressive. What kind of hosting do you use? I am using standard options of VPS hosting. Yes youre right, especially my categories+sub c. are too many. I did not want to be like that but nothing to do. I wrote several times in the forum but no solution. My 3. and 4. level subcategories are the same in all main categories. But have different ID's. For instance: 3. level: Clutch 4. level: Clutch Discs Renault / Clio / Clutch / Clutch Discs Renault / Kangoo / Clutch / Clutch Discs .... Citroen / C1 / Clutch / Clutch Discs Citroen / C2 / Clutch / Clutch Discs ...C3... ...C4... Its only one example, please guess it, for all cars and models, I have to set the same 3. and 4. levels with different ID's. Edited May 16, 2013 by Peda (see edit history) Link to comment Share on other sites More sharing options...
Peda Posted May 16, 2013 Share Posted May 16, 2013 For the solution I disabled the categories block module in modules page. I am using an external category module that loads only the top-level categories, then dynamically loads the subcategories using AJAX only when needed. I have to disabled Prestashops core categories block module to get performance of my site. Its ok. But I do not understand that why enabling New products block and Tags block are freezing my websites front page. Could you help me about this. Regards Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts