Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

SQL CUSTMIZE OF CS-CART Rate Topic   * * * * * 1 votes

 
  • cncinc
  • Senior Member
  • Members
  • Join Date: 23-Aug 12
  • 165 posts

Posted 17 December 2012 - 12:26 PM #1

i have 3.0.4 for cs-cart ultimate.
now WE are uploaded a lot of product .we installed QZIP AND REDUCE PRODUCT ON MAINPAGE AND ETC ALL WHAT WE CAN DO.
but still slowwwwwwwwwww.
so finally so many programer said ""why cs-cart call all db line. (our DB line 490,000 ) to show 10 product on main page.
also when i click one category , it calls 490,000 all db line. why?
i do not understand. so DB hardware can not hang on . i use my private server with 8GB RAM
I7 CPU , SSD 128GB ... DO YOU THINK THAT I use bad server ?
so can you custmize my SQL ,, TO CALL ONLY necessary DB query.
please so many cs-cart user want it.
thanks



SELECT SQL_CALC_FOUND_ROWS products.product_id, products.product_code, products.product_type, products.status, products.company_id, products.list_price, products.amount, products.weight, products.tracking, products.is_edp, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, companies.company as company_name, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_descr.product_id IS NOT NULL, shared_descr.short_description, descr1.short_description) as short_description, IF(shared_descr.product_id IS NOT NULL, IF(shared_descr.short_description = '', shared_descr.full_description, ''), IF(descr1.short_description = '', descr1.full_description, '')) as full_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_keywords, descr1.meta_keywords) as meta_keywords, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_description, descr1.meta_description) as meta_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.search_words, descr1.search_words) as search_words, IF(shared_prices.product_id IS NOT NULL, MIN(shared_prices.price), MIN(prices.price)) as price, cscart_seo_names.name as seo_name, IF(COUNT(IF(cscart_categories.company_id = products.company_id, NULL, cscart_categories.company_id)), 'Y', 'N') as is_shared_product FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products

 
  • cncinc
  • Senior Member
  • Members
  • Join Date: 23-Aug 12
  • 165 posts

Posted 17 December 2012 - 12:28 PM #2

so many people has wrong information . they did GZIP, compress,and APC, etc . and asking why still slow?
problem is query, as much as product your DB HARDWARE WILL BE DIE. my server is 8GB RAM,128SSD,QURD CORE 3.6

 
  • cncinc
  • Senior Member
  • Members
  • Join Date: 23-Aug 12
  • 165 posts

Posted 17 December 2012 - 12:38 PM #3

I WOUNDER WHY DOES NOT USE "COUNT " INSTEAD OF ""SQL_CALC_FOUND_ROWS""

i need to know CS-CART developer IDEA? REALLY WOUNDER