How to delete from Database product out of stock?

[liuksas]

How to delete from Database product out of stock 

maybe someone will write a sql command? 

Edited February 23 by liuksas (see edit history)

[Prestashop Addict]

Why delete products out of stock, this is strange?

[liuksas]

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...

 

 

[Prestashop Addict]

there are on the same server with same php?

[liuksas]

yes, and the same module install..

[Prestashop Addict]

The speed can be different if you have different modules on sites. If you have phpmyadmin you can check the size of each table and compare, which ones are big, so you can investigate to how optimize.

[liuksas]

ok thanks,

another question:

what do you think about redis cache?

i try CacheMemcached  but its not help, the site was not faster...

I read online that redis is better?

[Prestashop Addict]

The best solution is to find what is causing slow website, and fix or remove. Did you notice huge data in some tables? Otherway you can use a Prestashop cache module like Cache Ultimate.

[ps8modules.com]

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);

 

Edited February 21 by ps8modules.com (see edit history)

[liuksas]

I activated in sql: 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);

but not help...

thank you for help 

 

who can tell me what kind of server is needed for 30k products with modifications?

 

everyone says you need a good server, but no one tells, what a good server means for prestashop 

my server: its bad server  what a good server means? 

AMD EPYC™ 7502P
(Zen2) with Simultaneous Multithreading

RAM:128 GB DDR4 ECC

Disk:optional (against surcharge)

Connection:1 GBit/s port

Bandwidth guaranteed:1 GBit/s

Backup Space:100 GB

Traffic:Unlimited *

 

[ps8modules.com]

Thank you, but I don't have an answer please.
How did you remove products from the eshop, where there are now 10k products?

The SQL I gave you should have returned some number.
what was it like

I'm trying to figure out why an eshop with 10k products is so slow and an eshop with 30k products is fast.
There will definitely be some mess in the database.

Edited February 21 by ps8modules.com (see edit history)