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: Shanti Subramanyam
Priority: Minor
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.
