[
https://issues.apache.org/jira/browse/OLIO-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Akara Sucharitakul resolved OLIO-47.
------------------------------------
Resolution: Fixed
> 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.
