Performance problem

Hi,

I had a big performance issue where a single query wiped out my whole CPU whilst Google bots were indexing my site. The query was

SELECT t.term_id FROM

wps_terms

AS t INNER JOIN

wps_term_taxonomy

AS tt ON t.term_id = tt.term_id LEFT JOIN

wps_term_relationships

as tr ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN

wps_posts

as p ON p.ID = tr.object_id INNER JOIN

wps_geodir_gd_place_detail

as pd ON pd.post_id = p.ID WHERE tt.taxonomy = ‘gd_placecategory’ AND p.post_status = ‘publish’ AND pd.post_locations LIKE ‘[worcester],[worcestershire],[united-kingdom]’ GROUP BY t.term_id ORDER BY COUNT(t.term_id) DESC

I have no upgraded yet but have you seen this before or anything you recommend?

Thanks,
Ian