[OLIO-47] Suboptimal and unnatural queries in taggedEvents.php (tag search)

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Component/s: php-app
• Assignee: Akara Sucharitakul
• Reporter: Akara Sucharitakul
• Created: 27/Jan/09 01:19
• Updated: 28/Jan/09 20:32
• Resolved: 27/Jan/09 01:22

Description

1. The query to obtain the number of references to a tag is done by select count... while there is already a refcount in the tags table. It is far more efficient to do a direct query on the tags table provided there is an index on the tag name (which should be rather natural).
2. The search query still uses subqueries. Should change to join.