Suboptimal and unnatural queries in taggedEvents.php (tag search)
-----------------------------------------------------------------
Key: OLIO-47
URL: https://issues.apache.org/jira/browse/OLIO-47
Project: Olio
Issue Type: Improvement
Components: php-app
Reporter: Akara Sucharitakul
Assignee: Akara Sucharitakul
Priority: Trivial
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
