need database optimizing help

  • Resolved linkdon

    (@linkdon)


    8 years, 2 months ago

    hello to everyone
    I do have some problem with WordPress database and I did a lot to solve that.
    but problem not been solved.

    my problem started from info that my host inform me.
    my database made a lot of query like this:

    SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = ‘_start_date_gdate’ AND wp_postmeta.meta_value != ” ) OR ( mt1.meta_key = ‘_start_time’ AND mt1.meta_value != ” )) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC:

    I did optimize my database with all the best plugin .
    but my wp_postmeta table is three times bigger than wp_posts.
    i think its the problem.

    how could I solve the issue?
    any help would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    8 years, 2 months ago

    wp_postmeta table is three times bigger than wp_posts.

    That’s reasonable as your posts probably have multiple bits of meta data associated with each.

    Where on your site does this query occur? Given that it mentions product, I assume you’re using some interesting sort order on your product pages. Have you checked your WooCommerce and theme settings related to product display?

    Thread Starter linkdon

    (@linkdon)

    8 years, 2 months ago

    thanks a lot.
    it was sorting issue that my theme has in front page.
    after increasing product the sorting page made a problem.
    i disabled the page and problem gone.

    • This reply was modified 8 years, 2 months ago by linkdon.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘need database optimizing help’ is closed to new replies.