|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Can someone help me optimize this query as it happens all the time. These queries appears at forum ID 96 I have there like 164,833 threads and 418,405 posts. And I can't figure out what is wrong. HTML Code: # User@Host: forums[forums] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 100 Rows_examined: 116077 SELECT threadid , title, lastpost, replycount FROM thread AS thread WHERE forumid = 96 AND visible = 1 AND open 10 ORDER BY dateline ASC LIMIT 5000,100; # User@Host: forums[forums] @ localhost [] # Query_time: 11 Lock_time: 0 Rows_sent: 100 Rows_examined: 115777 SELECT threadid , title, lastpost, replycount FROM thread AS thread WHERE forumid = 96 AND visible = 1 AND open 10 ORDER BY dateline ASC LIMIT 4700,100; # Time: 060609 19:52:25 # User@Host: forums[forums] @ localhost [] # Query_time: 12 Lock_time: 0 Rows_sent: 100 Rows_examined: 116177 SELECT threadid , title, lastpost, replycount FROM thread AS thread WHERE forumid = 96 AND visible = 1 AND open 10 ORDER BY dateline ASC LIMIT 5100,100; # Time: 060609 19:52:26 # User@Host: forums[forums] @ localhost [] # Query_time: 13 Lock_time: 0 Rows_sent: 100 Rows_examined: 116377 SELECT threadid , title, lastpost, replycount FROM thread AS thread WHERE forumid = 96 AND visible = 1 AND open 10 ORDER BY dateline ASC LIMIT 5300,100; __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
"List New Registrations" in admincp causes slow queries. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-17-2010 09:40 PM |
CMS Have the CMS slow queries been fixed? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 02-20-2010 05:40 AM |
CMS Queries - OMG ? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 01-06-2010 03:30 AM |
CMS Queries | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 11-13-2009 04:50 PM |
Slow queries. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-27-2009 10:50 PM |