jackrabbit-oak-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Dürig (JIRA) <j...@apache.org>
Subject [jira] [Commented] (OAK-2056) Optimize orderings by date fields
Date Fri, 12 Dec 2014 17:37:14 GMT

    [ https://issues.apache.org/jira/browse/OAK-2056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244488#comment-14244488
] 

Michael Dürig commented on OAK-2056:
------------------------------------

Dunno ISO8601 date format form the inside out. But from a quick glance the patch looks fine.

> Optimize orderings by date fields
> ---------------------------------
>
>                 Key: OAK-2056
>                 URL: https://issues.apache.org/jira/browse/OAK-2056
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.0.4, 1.0.8
>            Reporter: Przemo Pakulski
>            Assignee: Davide Giannella
>              Labels: performance
>         Attachments: OAK-2056-r1.patch
>
>
> 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.
> {noformat}
> Query execution times are as below
> ---------------------------------------
> No order clause 		|  0,147 sec
> ORDER BY [jcr:title]	        |  1,203 sec
> ORDER BY [jcr:createdBy]	|  1,018 sec
> ORDER BY [jcr:created]		| 25,229 sec
> {noformat}
> Ordering by date field adds extra 24 seconds overhead.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message