[daisy] [JIRA] Commented: (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=comments#action_13202 ] 

Bruno Dumon commented on DSY-488:
---------------------------------

>From a conceptual point of view things still work the same as in 1.5:
 * the query returns indeed all documents, since the condition you specified is true for all documents
 * Daisy then ACL filters these documents
 * and then calculates the distinct set for all selected values

Since you have > 10,000 documents, make sure the document cache setting in the myconfig.xml is appropriate, for example like this:

  <target path="/daisy/repository/documentcache">
    <configuration>
        <documentCacheMaxSize>15000</documentCacheMaxSize>
        <availableVariantsCacheMaxSize>15000</availableVariantsCacheMaxSize>
    </configuration>
  </target>

If the documents don't all fit in the cache anymore, that could explain why things are a lot slower.

If this isn't the reason, it will need some closer investigation as to why it became slower.

> 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