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 "Akara Sucharitakul (JIRA)" <ji...@apache.org> on 2009/01/27 01:20:59 UTC
[jira] Created: (OLIO-47) Suboptimal and unnatural queries in
taggedEvents.php (tag search)
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.
[jira] Closed: (OLIO-47) Suboptimal and unnatural queries in
taggedEvents.php (tag search)
Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (OLIO-47) Suboptimal and unnatural queries in
taggedEvents.php (tag search)
Posted by "Akara Sucharitakul (JIRA)" <ji...@apache.org>.
[ 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.