Support » Fixing WordPress » WPDB Query Slow on Multiple Taxonomy Search

  • Hello, I am doing something wrong.

    I added a custom search function that searches for taxonomy_terms.
    It works like a charm when I have 2/3 queries, but when I add more I end up having a 100% cpu process on mysql, and the server goes down.

    So, here is what I did:

    public static function queryTours() {
    		global $wpdb;
    		$query['select']="SELECT posts.ID FROM {$wpdb->posts} AS posts ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS destinations ON posts.ID=destinations.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS types ON posts.ID=types.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS categories ON posts.ID=categories.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS capacity ON posts.ID=capacity.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS rooms ON posts.ID=rooms.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS classification ON posts.ID=classification.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->term_relationships} AS features ON posts.ID=features.object_id ";
    		$query['select'].="INNER JOIN {$wpdb->postmeta} AS prices ON (posts.ID=prices.post_id AND prices.meta_key = '_" ."price') ";
    		$query['where']="WHERE (posts.post_status = 'publish' OR posts.post_status = 'private') ";
    		$query['where'].="AND posts.post_type = 'tour' ";

    The website is currently in localhost, as I am still developing it.

    Does anyone have any tips I could do to improve it? I’m kinda lost on this for about a week :/

  • The topic ‘WPDB Query Slow on Multiple Taxonomy Search’ is closed to new replies.