Support » Requests and Feedback » Stupid and unnessesary SQL queries

  • On the main page of my blog I have nearly 60 – 100 queries – most of them are:

    SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (366, 358, 349) ORDER BY t.name ASC

    SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (366,358,349) ORDER BY post_id, meta_key

    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND ( t.term_id = 4 ) ORDER BY t.name ASC

    SELECT * FROM wp_users WHERE ID = 17 LIMIT 1
    SELECT meta_key, m
    I don’t use any data from this queries so why WordPress is doing this queries. It’s very annoying and very slow.

    On wordpress 2.3 I hade 44 queries on wordpress 2.5 I have 60 – 110 queries and most of them are unnessesary ;/

  • The topic ‘Stupid and unnessesary SQL queries’ is closed to new replies.