No problem at all. I never mind helping when I have the time. And thanks for the link.
When I checked the time it takes for a poll on my test server that query was done in about 0.002 seconds. The only thing I can think of at the moment is maybe you have another hack installed that's affecting it?
You can try replacing the query:
PHP Code:
$pollinfo=$DB_site->query_first("SELECT poll.*,thread.* FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");{
With this one 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,thread.pollid,thread.open FROM poll LEFT JOIN thread ON (thread.pollid = poll.pollid) WHERE thread.forumid='$pollsforum' ORDER BY poll.dateline DESC LIMIT 1");{
The original query tells the script to select all columns from the thread and poll tables. The new one tells it to only select the fields that are really necessary. Normally it selecting a couple of extra fields shouldn't be a problem, but I guess it could be in this case. Anyways, try that and see if it helps any and if not I'll try to figure out something else.