Database performance


#1

Are there any limits in the number of objects that can be stored?

The need is to be able to manage a catalog of over 10 million products in different languages and variants.

Has anyone encountered performance problems with large numbers of objects?


#2

Hi,
from Pimcore side, there should be no limit. Of course you need to size and configure your database properly.

BR
Christian


#3

If you need to ask this question, you should maybe talk to a DB-engineer before switching to Pimcore!
For Databases a few million records should never be a problem, but you do need to configure the server(s) decently. Also, you could do a test on a VPS with (php) generated products and see if the performance is enough for you.