Jump to content

Very large number of products in the database


Recommended Posts

How does Prestashop deal with large numbers of products? is it possible to use multiple product databases?

The reason for this question is to set up a shop with 300,000 products from different suppliers.

Share this post

Link to post
Share on other sites

Hello @hartung

The most important part of this all is your server. For handling this amount of products your server need to be setup well.
First of all do not use Prestashop 1.6 which is much slower than 1.7.

make sure your server can handle PHP 7.3 which has an improved speed compared to PHP 5.

Make sure your webshop meets the system requirements  setup by Prestashop https://devdocs.prestashop.com/1.7/basics/installation/system-requirements/.
if you want to process large amounts of data, doubling the prestashop requirements is not an unnecessary luxury.

In the long run, you should also look at database optimizers that will remove unnecessary data. This prevents your database from being filled with unused data from a year ago.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More