2

How does the number of products affect magento/server performance?

I am considering deleting unused products in a magento multistore setup as I am only using 1 of the stores. I have over 25K skus but only using about 1k.

I am using magento 1.7.0.2 and have read about some catalog rewrite bug which can cause some slow queries.

5

What it affects the most are the indexers, not only the URL rewrite index, which indeed has a glitch in CE and disabling products does not remove them from the index. Also price index, attribute index for layered navigation, search index and flat article index. Incidentally those grow about linear to product count * store view count, so you should consider deleting your unused stores as well.

Indexing performance also is affected by number of combined products (bundle, configurable), number of categories, number of customer groups and number of filterable product attributes.

It's not unusual for a full reindex to take several hours, so I'd definitely recommend to optimize it where possible. Also partial reindex is affected, that means with less products, saving a product in the backend will be faster (if the indexers are configured as "update on save")

  • I don't know if I would call products not being removed from url rewrites upon disable as a "glitch". Just because a product is currently disabled doesn't mean you don't want it to have some SEO juice. – pspahn Mar 22 '15 at 20:05
  • How do dead entries in a database table give you "SEO juice"? These links are going to be 404 anyways. Also, disabled products are only part of the problem, the index also contains products that are not visible individually, so for example if you have a typical fashion store with lots of configurable products and lots of categories, there is a huge amount of unused data in the URL rewrite index. – Fabian Schmengler Mar 22 '15 at 22:03
1

I can confirm the already given answers by fschmengler and can give you only one advice. Keep your database as small as possible. There is no reason the keep inactive products inside the store database. Check you queries, finetune you database. Check buffer pool size for mysql. Keep query cache between 64 and 128MB. Check the Indexer queries. Disable unused modules via xml. Check you flat tables. Are all Attributes for Category listing inside the flat table. Are unused Attributes inside the database / flat tables. For category listing implement some prefetching for all Products to reduce the amount of database queries. Magento can easy handle 100k Skus if you keep an eye on what you are doing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.