liuksas Posted February 19 Share Posted February 19 (edited) How to delete from Database product out of stock maybe someone will write a sql command? Edited February 23 by liuksas (see edit history) Link to comment Share on other sites More sharing options...
Prestashop Addict Posted February 20 Share Posted February 20 Why delete products out of stock, this is strange? Link to comment Share on other sites More sharing options...
liuksas Posted February 20 Author Share Posted February 20 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... Link to comment Share on other sites More sharing options...
Prestashop Addict Posted February 20 Share Posted February 20 there are on the same server with same php? Link to comment Share on other sites More sharing options...
liuksas Posted February 20 Author Share Posted February 20 yes, and the same module install.. Link to comment Share on other sites More sharing options...
Prestashop Addict Posted February 20 Share Posted February 20 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. Link to comment Share on other sites More sharing options...
liuksas Posted February 21 Author Share Posted February 21 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? Link to comment Share on other sites More sharing options...
Prestashop Addict Posted February 21 Share Posted February 21 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. Link to comment Share on other sites More sharing options...
ps8modules Posted February 21 Share Posted February 21 (edited) 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) Link to comment Share on other sites More sharing options...
liuksas Posted February 21 Author Share Posted February 21 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 * Link to comment Share on other sites More sharing options...
ps8modules Posted February 21 Share Posted February 21 (edited) 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) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now