[etoys-notify] [JIRA] Created: (SQ-1133) performance bottleneck

[teefal (JIRA)]

performance bottleneck
----------------------

                 Key: SQ-1133
                 URL: http://tracker.squeakland.org/browse/SQ-1133
             Project: squeakland
          Issue Type: Bug
            Reporter: teefal
            Assignee: teefal
            Priority: Blocker


The showcase is swamped.  Try this query:

SELECT DISTINCT o.id, o.file_name, o.modify_stamp, o.modify_who, o.create_stamp, o.mojo, o.text, o.rank, o.read_count, o.photo_width, o.photo_height, o.thumb_width, o.thumb_height, o.original_width, o.original_height, o.attach_name, o.is_approved, o.is_public, o.uri, o.prev_uri, o.title, o.sub_title, o.blurb, o.title_link, o.author, o.author_email, o.post_date, o.custom_photo_width, o.custom_thumb_photo_width, o.custom_photo_height, o.custom_thumb_photo_height, o.attach_stamp, o.voter_count, o.parent, o.category, o.sm_group, o.lang_cat, o.original, o.account, o.movie, o.mailing, o.photo, o.bio, o.category_two, o.category_three, o.category_four FROM SmArticle o, SmAccount a 

WHERE (
        (
          (
            ('' = 'admin') OR (o.is_approved AND o.is_public AND (o.mojo > 0) )
          ) 
          OR 
          (-1 = o.account) 
        ) 
        AND o.original = 0 
        AND (o.category = 611) 
        AND (o.attach_name <> '')
      ) 
      
ORDER BY o.mojo DESC, o.post_date DESC, o.attach_stamp DESC LIMIT 0, 10  


Also, put back crontab:



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.squeakland.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira