skip to Main Content

Why is limit 0,1 slower than limit 0, 17 – Woocommerce

I'm trying to analyze why the following query is slower with LIMIT 0,1 than LIMIT 0,100 I've added SQL_NO_CACHE for testing purposes. Query: SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS wp_posts.*, low_stock_amount_meta.meta_value AS low_stock_amount FROM wp_posts LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id…

VIEW QUESTION
Back To Top
Search