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

teefal (JIRA) tracker at squeakland.org
Sun Oct 28 08:12:31 EDT 2012

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 

            ('' = 'admin') OR (o.is_approved AND o.is_public AND (o.mojo > 0) )
          (-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


More information about the etoys-notify mailing list