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

[Min Idzelis (JIRA)]

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