[Tigga]

I'm not quite sure if I follow you about it using all 5000 threads... The first query looks the way it should, though I'm still not sure why it would be taking so long to execute. The other query there is from the latest threads part of the hack where it is checking each forum.

If you want to try something else, you can try replacing the poll query with this on here:

PHP Code:

$pollinfo=$DB_site->query_first("SELECT poll.pollid,poll.question,poll.dateline,poll.options,poll.votes,poll.active,poll.numberoptions,poll.timeout,poll.multiple,poll.voters FROM poll ORDER BY poll.dateline DESC LIMIT 1");{ 


See what the time is like with that one and if it isn't improved, then try this one here:

PHP Code:

$pollinfo=$DB_site->query_first("SELECT thread.pollid,thread.open FROM thread WHERE thread.forumid='$pollsforum' ORDER BY thread.dateline DESC LIMIT 1");{ 


Neither of those will actually fix the problem or let the poll work properly, but the first one leaves out the call to the thread table, and the second one leaves out the call to the poll table. If either of those improves the time then we know which table it's taking so long to query and will at least know a little more about what's causing it. Also, if the first query reduces the time, I may be able to work around calling the thread table.