Very large number of products in the database

[Hartung]

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.

[delete-account-pleas]

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.