Slow Query

[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

[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]

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

[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.

[Jake Bunce]

Are search features enabled?

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

[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]

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]

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.

[Ian Cunningham]

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

[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]

Thanks Tim!

[xnetco]

Thanks Tim!

No worries, what's your forum url?

[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!