Thread: Database high RAM usage

Database high RAM usage

Hello!

My host contacted me about high RAM usage. He told me that this:

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, IF(
wp_posts.ID IN ( 287888,287773,287755), 1, 0) AS featured FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
onships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (223717) AND ( \n wp_term_relationships.term_taxonomy_id IN (23397)\n) AND wp_posts.p
ost_type = 'ad_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'tr_pending' OR wp_posts.post_status = 'tr_failed'
OR wp_posts.post_status = 'tr_completed' OR wp_posts.post_status = 'tr_activated') GROUP BY wp_posts.ID ORDER BY featured DESC, RAND() LIMI
T 0, 3

Is causing high RAM usage. He told me to improve this as the server crashes often when some people access the site.

Maybe somebody can help me with this!

Greetings

Julia