Indexing the tables !
cirotix - October 8, 2008 - 05:32
| Project: | Seesmic comment |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
There is a severe flaw for high traffic website.
This query is called for every comment view and the tables seesmic_videos and seesmic_comments are not indexed correctly. For this query you should add an index on seesmic_video_id on the table seesmic_comment
<?php
SELECT dsvid FROM {seesmic_videos} sv INNER JOIN {seesmic_comments} sc ON sv.seesmic_video_id = sc.seesmic_video_id WHERE sc.cid = %d
?>