[
https://issues.apache.org/jira/browse/OLIO-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Akara Sucharitakul resolved OLIO-14.
------------------------------------
Resolution: Fixed
> Several queries need to be improved for better performance.
> -----------------------------------------------------------
>
> Key: OLIO-14
> URL: https://issues.apache.org/jira/browse/OLIO-14
> Project: Olio
> Issue Type: Improvement
> Components: php-app
> Environment: Any
> Reporter: Akara Sucharitakul
> Assignee: Akara Sucharitakul
> Priority: Minor
> Time Spent: 1h
> Remaining Estimate: 0h
>
> Subqueries in Tags_Controller.php and taggedEvents.php are not optimal for
> MySQL below 6.0. This should be changed to more efficient joins as
> characterized by Richard Smith's blog (http://blogs.sun.com/wizard/).
> Also the query at friends.php:60 should be changed from:
> select count(*) as count from PERSON as p, PERSON_PERSON as pp where
> pp.person_username='$user' and p.username=pp.friends_username and
> pp.is_accepted=1
> to
> select count(*) as count from PERSON_PERSON as pp where
> pp.person_username='$user' and pp.is_accepted=1
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
