[daisy] [JIRA] Closed: (DSY-488) Very slow query for selection list based on query: "select ownerLogin where ownerLogin is not null"

[Bruno Dumon (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-488?page=all ]
     
Bruno Dumon closed DSY-488:
---------------------------

    Resolution: Invalid

No problem.

> Very slow query for selection list based on query: "select ownerLogin where ownerLogin is not null"
> ---------------------------------------------------------------------------------------------------
>
>          Key: DSY-488
>          URL: http://issues.cocoondev.org//browse/DSY-488
>      Project: Daisy
>         Type: Bug
>   Components: Frontend - doc editing - fields
>     Versions: 2.0.1
>     Reporter: Min Idzelis
>     Priority: Minor

>
> You have a field type with a selection list based on a query:
> select ownerLogin where ownerLogin is not null
> I turned on the mysql query log, and it seems to be running this query against all the documents in the repository (we have over 11,000) and so it is very slow (30 seconds even on fast hardware)
> This used to be a lot faster in Daisy 1.5. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira