Moving Old Products To More

Hi CS-Cart team,

I have a big problem. The server has slowed down due to the large number of products. On the other hand, this number of products have no special use and many of them are old. But our products are unique and we need their history and we can not delete them. Is it possible for you to specify an option in the product called Archive? To move the product there ?! In this way, the tables of the product and its accessories are lightened. And old products are removed from the main list of the site. On the other hand, whenever a user wants to access a particular product through a specific search or invoice, there is no problem. And it is possible that the Google index and Yandex will not be lost. And the product link is live.

Thanks your kind attention!

How many products do you have?

Hi CS-Cart team,

I have a big problem. The server has slowed down due to the large number of products. On the other hand, this number of products have no special use and many of them are old. But our products are unique and we need their history and we can not delete them. Is it possible for you to specify an option in the product called Archive? To move the product there ?! In this way, the tables of the product and its accessories are lightened. And old products are removed from the main list of the site. On the other hand, whenever a user wants to access a particular product through a specific search or invoice, there is no problem. And it is possible that the Google index and Yandex will not be lost. And the product link is live.

Thanks your kind attention!

try this: https://store.cart-power.com/discontinued-products.html

If you want those discontinued products to be visible in old orders/invoices and want a customer to be able to search them, then you will need to address your root-performance issue versus trying to move the data around and then enable access to it.

You might consider changing your product related tables to InnoDb versus MyIsam tables. MyIsam will lock a table while it does an insert whereby InnoDb will lock the row. However, there is more overhead to read an InnoDb table than a MyIsam.

As Harm asked, how many products does your Database have? How many options and variations? Where are you seeing the slowness?