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

[Min Idzelis (JIRA)]

    [ http://issues.cocoondev.org//browse/DSY-488?page=comments#action_13204 ] 

Min Idzelis commented on DSY-488:
---------------------------------

Boosting up the cache to 20000 did the trick. It's very fast now. This issue can be resolved. Thanks!

> 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