Trying to optimize query in forumdisplay.php

[RyanD789]

Hello all!

I am trying to find a way to optimize the query that comes from forumdisplay.php:

Example:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1187817369 AND open <> 10, 1, 0)) AS newthread FROM thread AS thread WHERE forumid = 19 AND sticky = 0 AND visible = 1 AND lastpost >= 1185226409

What I'd like to do is figure out what this query is used for specifically, and perhaps stuff the data into a memcache datastore, until changed, and force the memcache to update. Please let me know what this is use for, as sometimes, 50 of these stack up in the mysql processlist.

Thanks!