SQL Stopwatch ps_specific_price takes a lot of time to load up product

[Maximus Design]

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
As you see. You have any idea what I should do?

Prestashop 1.6.1.19

Edited November 24, 2023 by Maximus Design (see edit history)

[ps8modules]

Hi.

You need to check all the override files ( right in image ) and find out which module created the override. Then contact the developer.

[musicmaster]

Your ps_specific_prices table contains 360,000 entries. That is crazy.

Note that when you make a discount for a category with 100 products this results in 100 entries in this table. 

Start with deleting all discounts that have expired. And look then how many entries remain in this table.

[Maximus Design]

Hi, I talked to my team and we removed the catalog pricing rules and then I truncated this table.

Shops are moving as fast as ever