11-13-2009, 03:34 PM
|
|
|
|
Join Date: Oct 2006
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Query Almost Crashes Server
I have a Quad Core Server with 8GB Ram.
What uses this query, and why is it almost crashing the server?
Thanks.
Quote:
780816 nmu98_techguy localhost nmu98_mainforum Query 15 Sorting result SELECT th
read.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposte
r, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.u
sergroupid, user.displaygroupid^M\n\t\t\t\t\tFROM thread AS thread^M\n\t\t\t\t\tLEFT JOIN user AS
user ON (user.username = thread.lastposter)^M\n\t\t\t\t\tWHERE NOT ISNULL(thread.threadid) AND t
hread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(75,113,151,92,185,176,254,76,
263,255,77,110,93,257,189,3,163,164,269,268,270,21 8,264,172,200,206,212,223) ^M\n\t\t\t\t\tORDER
BY lastpost DESC^M\n\t\t\t\t\tLIMIT 0, 10
|
|
Threaded Mode