Anyone knows from where this query comes from?
SELECT COUNT(DISTINCT(products.product_id)) FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values ON cscart_product_features_values.product_id = products.product_id AND cscart_product_features_values.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_0 ON d_0.product_id = products.product_id AND d_0.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_1 ON d_1.product_id = products.product_id AND d_1.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_2 ON d_2.product_id = products.product_id AND d_2.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_3 ON d_3.product_id = products.product_id AND d_3.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_4 ON d_4.product_id = products.product_id AND d_4.lang_code = ‘RO’ LEFT JOIN cscart_product_features_values as d_5 ON d_5.product_id = products.product_id AND d_5.lang_code = ‘RO’ LEFT JOIN cscart_product_options_inventory as inventory ON inventory.product_id = products.product_id LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND cscart_categories.membership_id IN (0, 0) AND cscart_categories.status IN (‘A’, ‘H’) AND products.status IN (‘A’) LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = ‘p’ WHERE 1 AND d_0.variant_id = 16 AND d_1.variant_id = 16 AND d_2.variant_id = 16 AND d_3.variant_id = 16 AND d_4.variant_id = 16 AND d_5.variant_id = 14 AND prices.price >= 0.00 AND prices.price <= 50.00 AND IF(products.tracking = ‘O’, inventory.amount > 0, products.amount > 0) AND prices.membership_id IN (0, 0)
It’s killing my sql server.
That’s the administration backend, essentially if it’s crashing at this point without any modifications then it’s sufficient to say that your server cannot run CS-Cart.
[quote name=‘JesseLeeStringer’]That’s the administration backend, essentially if it’s crashing at this point without any modifications then it’s sufficient to say that your server cannot run CS-Cart.[/QUOTE]
Thank you for your answer, but If a IBM (dual xeon, with 4gb ram) dedicated server do not fit cs-cart needs, I’m wondering how many cs-cart clients should have this problem.
Actually, I found where the problem is (at least I hope I did).
I will post it here after I will resolve it completely. It has to do with filters/features, seo addon and google. 