Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiran.kc
Starting Member
1 Post |
 Posted - 2008-12-04 : 02:36:41
|
| # Query_time: 163sec Lock_time: 0 Rows_sent: 25 Rows_examined: 2043808SELECT p.id AS post_id, p.topic_id, t.forum_id, t.topic_title,t.count_replies, p.content, p.enable_bbcode, p.enable_smilies,p.enable_html, p.poster_id, m.displayed_name AS last_poster_name,p.poster_guest AS last_poster_guest, p.post_time FROM usebb_posts p LEFTJOIN usebb_members m ON p.poster_id = m.id, usebb_topics t WHEREt.forum_id IN(16, 19, 20, 21, 29, 30, 27, 26, 31) AND t.id = p.topic_idORDER BY p.post_time DESC LIMIT 25;am running a forum and sometimes its a bit slow.when contacted the server admin he sent me the above query and asked me to optimize the query.Can any one help me with this.?? am relatively new to this field. can i solve the problem to some extend by deleting unwanted posts from the front end?? waiting for ur reply.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-04 : 02:42:11
|
| i dont think you're using sql server. this is ms sql server forum. try your luck in www.dbforums.com |
 |
|
|
|
|
|
|
|
Help with Query Optimisation