You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Luca Tagliani (JIRA)" <ji...@apache.org> on 2013/04/12 12:32:16 UTC

[jira] [Created] (JCR-3567) SQL2 query doesn't respect resultFetchSize value specified in workspace.xml

Luca Tagliani created JCR-3567:
----------------------------------

             Summary: SQL2 query doesn't respect resultFetchSize value specified in workspace.xml
                 Key: JCR-3567
                 URL: https://issues.apache.org/jira/browse/JCR-3567
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: query
    Affects Versions: 2.6
         Environment: Linux Mint 14 64bit 8Gb Ram
            Reporter: Luca Tagliani
            Priority: Critical


Using SQL2 query language, in a repository with nearly 1200000 node of the same type, even if it's specified a resultFetchSize of 1000 in workspace.xml, a query to retrieve all the nodes, tries to recover from the DB all the results.

Using an XPATH query all works as expected.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira