[OLIO-14] Several queries need to be improved for better performance.

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Component/s: php-app
• Environment: Any
• Assignee: Akara Sucharitakul
• Reporter: Akara Sucharitakul
• Created: 21/Nov/08 00:35
• Updated: 15/Jan/09 17:12
• Resolved: 14/Jan/09 05:05

Description

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