Please help me fix the Query

[nt1303]

Hi all,

My Current SQL Server is high load. Who can help me find out the query & fix it ?

Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228099'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228191'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228190'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228185'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228208'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228209'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228191'
Query 1 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228209'
Query 0 Copying to tmp table SELECT COUNT(*) AS posts, threadid FROM post WHERE visible = '1' AND dateline >= '1228134'

Thank You

Best Regards,
Ngoc Thang

[Jake Bunce]

I recommend you post in the Server Configuration forum. Post the info requested in this thread and they will be able to make recommendations:

http://www.vbulletin.com/forum/showthread.php?t=70117

But if you are on a shared server then they will probably just tell you to upgrade to a better server.

[nt1303]

Thanks Jake Bunce

Happy New Year !!!