Title: need database optimizing help
Last modified: February 2, 2018

---

# need database optimizing help

 *  Resolved [linkdon](https://wordpress.org/support/users/linkdon/)
 * (@linkdon)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/need-database-optimizing-help/)
 * 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)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [8 years, 2 months ago](https://wordpress.org/support/topic/need-database-optimizing-help/#post-9934805)
 * > 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?
    -  This reply was modified 8 years, 2 months ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).
 *  Thread Starter [linkdon](https://wordpress.org/support/users/linkdon/)
 * (@linkdon)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/need-database-optimizing-help/#post-9944599)
 * 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](https://wordpress.org/support/users/linkdon/).

Viewing 2 replies - 1 through 2 (of 2 total)

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [linkdon](https://wordpress.org/support/users/linkdon/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/need-database-optimizing-help/#post-9944599)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics