Edit History

On 2/20/2024 at 1:33 PM, liuksas said:

I want to optimize databases   

I have 2 stores, one with 10k products and the other with 30 and the one with 30 works better..

same theme.

 

I moved a lot of  time product and deleted them, maybe they stay in the databases...

 

 

Hi.

How did you remove the products please? Did you delete them in the database? They are products stored in multiple tables. If they stay somewhere, it can cause the e-shop to slow down.

You can test, for example, the following SQL query in the database:

SELECT COUNT(a.id_product) AS missing_product FROM ps_product_shop a WHERE a.id_product NOT IN (SELECT b.id_product FROM ps_product b);

On 2/20/2024 at 1:33 PM, liuksas said:

I want to optimize databases   

I have 2 stores, one with 10k products and the other with 30 and the one with 30 works better..

same theme.

 

I moved a lot of  time product and deleted them, maybe they stay in the databases...

 

 

Hi.

How did you remove the products please? Did you delete them in the database? They are products stored in multiple tables. If they stay somewhere, it can cause the e-shop to slow down.

You can test, for example, the following SQL query in the database:

SELECT a.id_product FROM ps_product_shop a WHERE a.id_product NOT IN (SELECT b.id_product FROM ps_product b);