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 2008/11/21 00:36:44 UTC

[jira] Created: (OLIO-14) Several queries need to be improved for better performance.

Several queries need to be improved for better performance.
-----------------------------------------------------------

                 Key: OLIO-14
                 URL: https://issues.apache.org/jira/browse/OLIO-14
             Project: Olio
          Issue Type: Improvement
          Components: php-app
         Environment: Any
            Reporter: Akara Sucharitakul
            Assignee: Shanti Subramanyam
            Priority: Minor


Subqueries in Tags_Controller.php and taggedEvents.php are not optimal for MySQL below 6.0. This should be changed to more efficient joins as characterized by Richard Smith's blog (http://blogs.sun.com/wizard/).

Also the query at friends.php:60 should be changed from:

select count(*) as count from PERSON as p, PERSON_PERSON as pp where pp.person_username='$user' and p.username=pp.friends_username and pp.is_accepted=1

to

select count(*) as count from PERSON_PERSON as pp where pp.person_username='$user' and pp.is_accepted=1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (OLIO-14) Several queries need to be improved for better performance.

Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OLIO-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shanti Subramanyam closed OLIO-14.
----------------------------------


This fix is essential if running MySQL 5.x and scaling to beyond 1500 users.

> Several queries need to be improved for better performance.
> -----------------------------------------------------------
>
>                 Key: OLIO-14
>                 URL: https://issues.apache.org/jira/browse/OLIO-14
>             Project: Olio
>          Issue Type: Improvement
>          Components: php-app
>         Environment: Any
>            Reporter: Akara Sucharitakul
>            Assignee: Akara Sucharitakul
>            Priority: Minor
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> Subqueries in Tags_Controller.php and taggedEvents.php are not optimal for MySQL below 6.0. This should be changed to more efficient joins as characterized by Richard Smith's blog (http://blogs.sun.com/wizard/).
> Also the query at friends.php:60 should be changed from:
> select count(*) as count from PERSON as p, PERSON_PERSON as pp where pp.person_username='$user' and p.username=pp.friends_username and pp.is_accepted=1
> to
> select count(*) as count from PERSON_PERSON as pp where pp.person_username='$user' and pp.is_accepted=1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Resolved: (OLIO-14) Several queries need to be improved for better performance.

Posted by "Akara Sucharitakul (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OLIO-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akara Sucharitakul resolved OLIO-14.
------------------------------------

    Resolution: Fixed

> Several queries need to be improved for better performance.
> -----------------------------------------------------------
>
>                 Key: OLIO-14
>                 URL: https://issues.apache.org/jira/browse/OLIO-14
>             Project: Olio
>          Issue Type: Improvement
>          Components: php-app
>         Environment: Any
>            Reporter: Akara Sucharitakul
>            Assignee: Akara Sucharitakul
>            Priority: Minor
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> Subqueries in Tags_Controller.php and taggedEvents.php are not optimal for MySQL below 6.0. This should be changed to more efficient joins as characterized by Richard Smith's blog (http://blogs.sun.com/wizard/).
> Also the query at friends.php:60 should be changed from:
> select count(*) as count from PERSON as p, PERSON_PERSON as pp where pp.person_username='$user' and p.username=pp.friends_username and pp.is_accepted=1
> to
> select count(*) as count from PERSON_PERSON as pp where pp.person_username='$user' and pp.is_accepted=1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Assigned: (OLIO-14) Several queries need to be improved for better performance.

Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OLIO-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shanti Subramanyam reassigned OLIO-14:
--------------------------------------

    Assignee: Akara Sucharitakul  (was: Shanti Subramanyam)

> Several queries need to be improved for better performance.
> -----------------------------------------------------------
>
>                 Key: OLIO-14
>                 URL: https://issues.apache.org/jira/browse/OLIO-14
>             Project: Olio
>          Issue Type: Improvement
>          Components: php-app
>         Environment: Any
>            Reporter: Akara Sucharitakul
>            Assignee: Akara Sucharitakul
>            Priority: Minor
>
> Subqueries in Tags_Controller.php and taggedEvents.php are not optimal for MySQL below 6.0. This should be changed to more efficient joins as characterized by Richard Smith's blog (http://blogs.sun.com/wizard/).
> Also the query at friends.php:60 should be changed from:
> select count(*) as count from PERSON as p, PERSON_PERSON as pp where pp.person_username='$user' and p.username=pp.friends_username and pp.is_accepted=1
> to
> select count(*) as count from PERSON_PERSON as pp where pp.person_username='$user' and pp.is_accepted=1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.