[etoys-notify] [JIRA] Updated: (SQ-1133) performance bottleneck
teefal (JIRA)
tracker at squeakland.org
Sun Oct 28 08:32:32 EDT 2012
[ http://tracker.squeakland.org/browse/SQ-1133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
teefal updated SQ-1133:
-----------------------
Description:
The showcase is swamped. Try this query (findAttachPageWithCatByRank)
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:
0,20,40 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/pr-poll
30 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/resendBallots
1 12 * * 1 /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/weeklyWow
was:
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:
0,20,40 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/pr-poll
30 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/resendBallots
1 12 * * 1 /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/weeklyWow
> 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 (findAttachPageWithCatByRank)
> 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:
> 0,20,40 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/pr-poll
> 30 * * * * /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/resendBallots
> 1 12 * * 1 /usr/bin/wget -nd -b -o /home/immuexa/www/squeakland/WEB-INF/logs/wget.log -O /dev/null http://squeakland.org/weeklyWow
--
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