You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Przemo Pakulski (JIRA)" <ji...@apache.org> on 2014/08/27 11:34:57 UTC

[jira] [Created] (OAK-2056) Optimize ordering by date fields

Przemo Pakulski created OAK-2056:
------------------------------------

             Summary: Optimize ordering by date fields
                 Key: OAK-2056
                 URL: https://issues.apache.org/jira/browse/OAK-2056
             Project: Jackrabbit Oak
          Issue Type: Improvement
          Components: query
    Affects Versions: 1.0.4
            Reporter: Przemo Pakulski


Sorting by date fields is very slow in oak, especially if result set size is large.

I'm running the following JCR-SQL2 query

{code}
SELECT * FROM [cq:PageContent] AS [c] WHERE ISDESCENDANTNODE('/content')
{code}

which returns 3270 results on my oak repo.

Query execution times are as below
---------------------------------------
No order clause 			|  0,147 sec
ORDER BY [jcr:createdBy]	|  1,018 sec
ORDER BY [jcr:created]		| 25,229 sec

Ordering by date field adds extra 24 seconds overhead.





--
This message was sent by Atlassian JIRA
(v6.2#6252)