webkod Posted December 13, 2013 Share Posted December 13, 2013 (edited) Hi, has anyone experience on a wide range of categories and products in PrestaShop, for example over 100,000 products? Thanks... Edited December 15, 2013 by webkod (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 13, 2013 Share Posted December 13, 2013 make sure you use a menu (categories) that supports caching of menu. Link to comment Share on other sites More sharing options...
webkod Posted December 13, 2013 Author Share Posted December 13, 2013 Thanks for the answer! But do you know a shop in Presta that has large database of categories and products? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 13, 2013 Share Posted December 13, 2013 PrestaShop an support number of categories as defined in mysql tables for category/product both tables have an id size of int(10) Link to comment Share on other sites More sharing options...
webkod Posted December 13, 2013 Author Share Posted December 13, 2013 I konw that database can take that number of information, but I will like to know if shop with more than 100.000 products exist in presta and is it working fine and fast? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 13, 2013 Share Posted December 13, 2013 you may then want to change your subject to get shop owners with that large of product shop. Link to comment Share on other sites More sharing options...
webkod Posted December 13, 2013 Author Share Posted December 13, 2013 Thanks, how can I change the subject and what do I write in subject to get shop owners with that large of product shop? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 13, 2013 Share Posted December 13, 2013 edit the original post, then http://screencast.com/t/EudEmvV8a you can then update the subject...I will check later and if you got it done...I'll delete out the non relevant stuff...like this post I assume of course you are experienced at running domains with large number database, i.e. vps/dedicated....i.e. you are not going to try this on a 'shared' hosting or other low level hosting plan. If not update the original post...and ask about that as well... after you update I will move to a configuring prestashop for more exposure. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted December 15, 2013 Share Posted December 15, 2013 moved to different forum topic for better community exposure. Link to comment Share on other sites More sharing options...
Bill Dalton Posted December 15, 2013 Share Posted December 15, 2013 (edited) Prestashop uses PHP and MySQL. Facebook and Twitter use them as well. You can have lots of people post that they are using 100,000 products. The proof that large amounts of data can be handled by PHP and MySQL are plentiful. That isn't the question. The questions are what hardware do you need to host 100,000 products. What is the best way to tune PHP and MySQL in relation to my available ram and requests per second. Edited December 15, 2013 by Bill Dalton (see edit history) Link to comment Share on other sites More sharing options...
webkod Posted December 15, 2013 Author Share Posted December 15, 2013 Bill Dalton, thanks for the answer, so presta can handle milion products but operation and stability and speed depends on the server where the host? Link to comment Share on other sites More sharing options...
Bill Dalton Posted December 15, 2013 Share Posted December 15, 2013 for example over 100,000 products? so presta can handle milion products For a 100,000 products learn about dedicated servers, and learn to maximize PHP and SQL. If you want to go to millions of products then you will need to learn about cloud computing such as Amazon EC2 or Windows Azure. These platforms make scaling easy and are comparatively economical. Link to comment Share on other sites More sharing options...
webkod Posted December 15, 2013 Author Share Posted December 15, 2013 Thanks yor your answers, this topic is solved for me Link to comment Share on other sites More sharing options...
Recommended Posts