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 "Julian Reschke (JIRA)" <ji...@apache.org> on 2019/05/16 11:01:00 UTC
[jira] [Comment Edited] (OAK-8002) RDBDocumentStore: add
RDB-specific MissingLastRevSeeker
[ https://issues.apache.org/jira/browse/OAK-8002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16840742#comment-16840742 ]
Julian Reschke edited comment on OAK-8002 at 5/16/19 11:00 AM:
---------------------------------------------------------------
trunk: (1.12.0) [r1852135|http://svn.apache.org/r1852135]
1.10: [r1859333|http://svn.apache.org/r1859333]
1.8: [r1859367|http://svn.apache.org/r1859367]
was (Author: reschke):
trunk: (1.12.0) [r1852135|http://svn.apache.org/r1852135]
1.10: [r1859333|http://svn.apache.org/r1859333]
> RDBDocumentStore: add RDB-specific MissingLastRevSeeker
> --------------------------------------------------------
>
> Key: OAK-8002
> URL: https://issues.apache.org/jira/browse/OAK-8002
> Project: Jackrabbit Oak
> Issue Type: Technical task
> Components: rdbmk
> Reporter: Julian Reschke
> Assignee: Julian Reschke
> Priority: Minor
> Fix For: 1.12.0, 1.10.3, 1.8.14
>
> Attachments: OAK-8002.diff
>
>
> {{MissingLastRevSeeker}} is slow on DB2. This is because the generic {{MissingLastRevSeeker}} gets candidates in batches (of 100), but in order to do batching, requires results to be sorted by ID.
> For DB2 we by default have indices on both ID and MODIFIED, but contrary to our expection a query that involves both indices does not perform well. Adding a compound index on ID *and* MODIFIED improves performance, but I'm hesitant to add this just to improve a recovery job.
> A more logical approach would be not to require batching/sorting by adopting the approach in {{MongoMissingLastRevSeeker}} which doesn't require sorting by ID in the first place.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)