| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
|---|---|---|---|---|---|---|---|---|---|
| 0001529 | Site | forum | public | 2009-08-03 22:20 | 2010-03-07 13:15 | ||||
| Reporter | tvo | ||||||||
| Assigned To | tvo | ||||||||
| Priority | normal | Severity | major | Reproducibility | always | ||||
| Status | resolved | Resolution | fixed | ||||||
| Product Version | springrts.com | ||||||||
| Target Version | Fixed in Version | ||||||||
| Summary | 0001529: find a new RSS feed phpbb mod, or optimize it's queries | ||||||||
| Description | the current one examines up to 900000 records for each fetch ... | ||||||||
| Additional Information | Some random samples from slow query log: # Query_time: 26 Lock_time: 0 Rows_sent: 50 Rows_examined: 914981 SELECT DISTINCT f.forum_id, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.post_attachment FROM (phpbb3_forums f, phpbb3_topics t, phpbb3_posts p) LEFT JOIN phpbb3_forums sf ON (f.left_id BETWEEN sf.left_id AND sf.right_id) WHERE t.topic_moved_id = 0 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id ) AND p.post_id = t.topic_last_post_id AND f.forum_id NOT IN (3, 4, 5, 8, 27, 28, 29) GROUP BY p.post_id ORDER BY p.post_time DESC LIMIT 50; # Query_time: 7 Lock_time: 0 Rows_sent: 100 Rows_examined: 853862 SELECT DISTINCT f.forum_id, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, t.topic_id, t.topic_last_post_time, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, p.post_id, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.post_attachment FROM (phpbb3_forums f, phpbb3_topics t, phpbb3_posts p) LEFT JOIN phpbb3_forums sf ON (f.left_id BETWEEN sf.left_id AND sf.right_id) WHERE t.topic_moved_id = 0 AND ( f.forum_id = p.forum_id AND p.topic_id = t.topic_id ) AND ( f.forum_id = 1 OR sf.forum_id = 1 ) AND p.post_id = t.topic_last_post_id AND f.forum_id NOT IN (3, 4, 5, 8, 17, 18, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37,38, 39, 47, 48, 49, 50) GROUP BY p.post_id, f.forum_id ORDER BY p.post_time DESC LIMIT 100; # Query_time: 6 Lock_time: 0 Rows_sent: 100 Rows_examined: 359065 SELECT f.forum_id, f.forum_password, f.forum_name, f.parent_id, f.left_id, f.right_id, p.post_id, p.poster_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.post_attachment FROM (phpbb3_forums f, phpbb3_posts p) WHERE p.post_approved = 1 AND f.forum_id = p.forum_id ORDER BY p.post_time DESC LIMIT 100; | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
tvo (reporter) 2010-03-07 13:15 |
solved by upgrade of phpbb to 3.0.6 (included fast RSS feed) |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-08-03 22:20 | tvo | New Issue | |
| 2010-03-07 13:15 | tvo | Note Added: 0004734 | |
| 2010-03-07 13:15 | tvo | Status | new => resolved |
| 2010-03-07 13:15 | tvo | Resolution | open => fixed |
| 2010-03-07 13:15 | tvo | Assigned To | => tvo |
| Issue History |