an
groups-icon

Slow queries and wp_postmeta file causing fair use with my hosting company

Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    Bob Jean
    0 points
    Beginner

    I have a 75000 listing directory set up. My query’s are running very slow. If I choose a category it’s slow to get to the search page, but when I drill down to the detail page it is very, very slow. I just got a service notice from my provider from only 645 queries on my post_meta file. They said it must have junk entries but when i cleaned it and optimized it it didn’t change much at all.

    For 73,898 rows in my wp_posts I have a post meta file that is 1328356 rows in my post_meta table. The post_meta table is 77.3MB with an index length of 40.2MB. I need to keep the service provider fair use police off my back, but I really would like to speed up my searches.

    Any ideas?

    Thanks in advance,
    Bob@BobJean.com

    July 31, 2015 at 2:11 pm
  • Mark Fail
    11,847 points
    Platinum User
    Bronze User Silver User Gold User Platinum User Helpful Award Fast Responder Thank You Coffee Villian Award Video Testimonial
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 31, 2015 at 3:43 pm
  • Bob Jean
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    July 31, 2015 at 3:52 pm

247

Views

2

Replies