Announcement

Collapse
No announcement yet.

Trying to optimize query in forumdisplay.php

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trying to optimize query in forumdisplay.php

    Hello all!

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

    Example:
    Code:
    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X