You are viewing a plain text version of this content. The canonical link for it is here.

Posted to olio-dev@incubator.apache.org by "Shanti Subramanyam (JIRA)" <ji...@apache.org> on 2009/01/28 20:32:59 UTC

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

     [ https://issues.apache.org/jira/browse/OLIO-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shanti Subramanyam closed OLIO-47.
----------------------------------


> 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.