Quote:
Originally Posted by MarkFL
There's only 1 query:
PHP Code:
$recent_posts = $vbulletin->db->query_read("
SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid
FROM " . TABLE_PREFIX . "post AS post
INNER JOIN " . TABLE_PREFIX . "thread AS thread
ON thread.threadid = post.threadid
ORDER BY post.dateline DESC
");
Information about the posts as well as the threads they inhabit are needed. If anyone sees how to make that query more efficient, I'm all ears. 
|
NOT the queries of the mod itself, the amount of queries the server has to do in order to create the executable file for the page source. For whatever reason, this mod greatly increases it.
Quote:
I have it working on our dev site, on the same server.
|
Would you mind sending me that link via PM?
Meanwhile, i can turn this back on at my live site, and you can go there and see what kind of "lag" you get, significant or not.