Results 1 to 1 of 1

Thread: Index on cp_ad_pop_total recommendation

  1. #1
    Affiliate Member AppThemes Affiliate jafo232's Avatar
    Join Date
    Mar 2011
    Location
    United States
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Index on cp_ad_pop_total recommendation

    We have heavily modified Classipress so it could very well be that this is not 100% necessary, but we found when sorting by popular ads, this is part of the query:

    Code:
    LEFT JOIN wp_cp_ad_pop_total a  ON (wp_posts.ID = a.postnum AND a.postcount > 0)
    This can be a pretty harsh condition on a site with many ads (over 3,000). We had some of these queries taking up to 25 seconds to complete. By adding an index for the postnum column, it reduced it to well under a second.

    Just a suggestion.

    Cheers!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Plugin Recommendation
    By philparsons85 in forum ClassiPress General Discussion
    Replies: 1
    Last Post: November 14th, 2013, 07:59 AM
  2. Twitter Plugin Recommendation please...
    By aj270303 in forum ClassiPress General Discussion
    Replies: 3
    Last Post: June 21st, 2012, 08:01 AM
  3. Recommendation bug tracking system
    By weiching in forum Showcase & Feedback
    Replies: 5
    Last Post: January 26th, 2012, 08:40 AM
  4. Index.php & Index.html Question
    By goblinnetwork in forum WordPress General Discussion
    Replies: 5
    Last Post: October 16th, 2011, 10:48 AM