Slow Query

[Ian Cunningham]

It's one I'm testing a new design on via a local server (using XAMPP) - I dumped all the old threads in to one forum while I was testing things out, which might explain it!

[xnetco]

Thanks Tim!

No worries, what's your forum url?

[Ian Cunningham]

Thanks Tim!

[xnetco]

Did you find out where this query comes from xnetco? I have the same problem

Yes, we did it turned out too many posts in a forum. We pruned them and it seemed to go away.

Tim

[Ian Cunningham]

Did you find out where this query comes from xnetco? I have the same problem

[xnetco]

I don't have any other guesses as to where that query is coming from unless it is from one of your addon products.

ok thanks. I'll have a closer look.

[Jake Bunce]

I don't have any other guesses as to where that query is coming from unless it is from one of your addon products.

[xnetco]

Are search features enabled?

Admin CP -> vBulletin Options -> Message Searching Options -> Search Engine Enabled

Thanks Jake

I don't think it's that as I've replaced the search with sphinx. Any ideas where else that query is coming from?

[Jake Bunce]

Are search features enabled?

Admin CP -> vBulletin Options -> Message Searching Options -> Search Engine Enabled

[xnetco]

That looks like it might have something to do with the New Posts link in the navbar. The search features can be intensive. One option is to disable the search features.

The forum url is www.celticminded.com if that helps.

[xnetco]

That looks like it might have something to do with the New Posts link in the navbar. The search features can be intensive. One option is to disable the search features.

Thanks Jacke.

That's not enabled as far as I can tell. Do you know what else it would be?

Tim

[Jake Bunce]

That looks like it might have something to do with the New Posts link in the navbar. The search features can be intensive. One option is to disable the search features.

[xnetco]

Hello.

I can see the following thread running quite regularly and takes a few seconds to complete. Can you tell me what it's doing?

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1226528337 AND open <> 10, 1, 0)) AS newthread

Cheers

Tim