[
https://issues.apache.org/jira/browse/OAK-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18085774#comment-18085774
]
Julian Reschke commented on OAK-9780:
-------------------------------------
trunk: (1.46.0)
[d005718e98|https://github.com/apache/jackrabbit-oak/commit/d005718e989e09b1af5aee3f5999fedf639a7d29]
[d73db4ec3e|https://github.com/apache/jackrabbit-oak/commit/d73db4ec3e11a03fb5ec90b857334338a14744c6]
[3086a9eab9|https://github.com/apache/jackrabbit-oak/commit/3086a9eab972a6e44c5108a9f9d2f91fdfef354c]
[6129c0947f|https://github.com/apache/jackrabbit-oak/commit/6129c0947fe409154a9eb820e1033295b9d96403]
[754d9fc1c2|https://github.com/apache/jackrabbit-oak/commit/754d9fc1c2917d131ca3ec17f8765e9c09d013ff]
[f5978a6994|https://github.com/apache/jackrabbit-oak/commit/f5978a6994cbe01d4f5ced85b7ab96f8688c1085]
[5f31e89530|https://github.com/apache/jackrabbit-oak/commit/5f31e895300d1d19ab2b2229bea16664b5410005]
(1.44.0)
[51bbf982f1|https://github.com/apache/jackrabbit-oak/commit/51bbf982f1b7eb19ec197a1d2c5b8ef25663833b]
[e3f2c83479|https://github.com/apache/jackrabbit-oak/commit/e3f2c83479159934b4b4e3609387c0dc8a25dc80]
[3daf39292b|https://github.com/apache/jackrabbit-oak/commit/3daf39292b2a6dbc2769bdf2d8b3c81e92b3bd30]
[4bdc32b8d5|https://github.com/apache/jackrabbit-oak/commit/4bdc32b8d5a877b955d1dda1ab7bd4f255ac3b78]
[5f8a17634d|https://github.com/apache/jackrabbit-oak/commit/5f8a17634ddc488590d8d59fdf9873d9a5ce25ce]
[7c7e1e9861|https://github.com/apache/jackrabbit-oak/commit/7c7e1e9861830e9bfa978ba451a2b9232d75d699]
[a8f08e4239|https://github.com/apache/jackrabbit-oak/commit/a8f08e423984aecff09f0a06f9c6ec8684f61b0c]
[a6ed7b1a2c|https://github.com/apache/jackrabbit-oak/commit/a6ed7b1a2cd651812b0114fffe0aca9e1bf6aefa]
[ddb1ef6b57|https://github.com/apache/jackrabbit-oak/commit/ddb1ef6b57cc519dcf87efecfdf9cda0b1414b9f]
[13bb08f8d8|https://github.com/apache/jackrabbit-oak/commit/13bb08f8d8a8e9b33372cf78e22ec50441678b1f]
[89f8fe9cad|https://github.com/apache/jackrabbit-oak/commit/89f8fe9cad509175ae52d1d8a1172536c61131c1]
[7def7d18c2|https://github.com/apache/jackrabbit-oak/commit/7def7d18c23df16ef34c931fb8add3b94b5f8e32]
[61384b8bc1|https://github.com/apache/jackrabbit-oak/commit/61384b8bc15f5706a303dbdf623f69b3c972379d]
[859387c134|https://github.com/apache/jackrabbit-oak/commit/859387c13421e2e826850c55c716f0448cc83e86]
[b7b413966f|https://github.com/apache/jackrabbit-oak/commit/b7b413966f100b50744c3fa592210b6ed2e93c61]
[83b43c7dce|https://github.com/apache/jackrabbit-oak/commit/83b43c7dce4dc29742f985aa3e29318811a42dc6]
[012c72bab6|https://github.com/apache/jackrabbit-oak/commit/012c72bab63ade916e17065e52572746ee09854b]
[8b7c3a7335|https://github.com/apache/jackrabbit-oak/commit/8b7c3a7335931b50db4a982749acea28f281cdf1]
[5c252f868d|https://github.com/apache/jackrabbit-oak/commit/5c252f868defee565438f063c188f5e327133190]
[880c2c017b|https://github.com/apache/jackrabbit-oak/commit/880c2c017bb00ca73b86e0a89db4fc4fec628c67]
[c480532e0b|https://github.com/apache/jackrabbit-oak/commit/c480532e0b5ebb147bac95302da81d14e5d07381]
> Prefetch node states
> --------------------
>
> Key: OAK-9780
> URL: https://issues.apache.org/jira/browse/OAK-9780
> Project: Jackrabbit Oak
> Issue Type: New Feature
> Components: api, core, documentmk
> Reporter: Stefan Egli
> Assignee: Marcel Reutegger
> Priority: Major
> Fix For: 1.46.0
>
>
> Cache warming for DocumentNodeStore. Goal is for indexing to warm up the
> cache for a select few eg paths to allow for faster iterating/reading of the
> same eg paths later on.
> Example usage
> The common usage is to read a number of query result paths from the index
> (depending on the configured prefetch count), and then prefetches these nodes
> from the node store. To enable prefetch for all queries, use the
> QueryEngineSettings JMX bean, setting "PrefetchCount" (default 0). Also
> supported is enabling prefetch for an individual query, by appending
> "option(prefetches <number of nodes>)":
> {noformat}
> select * from [dam:Asset]
> where contains(*, 'admin')
> option(prefetches 100)
> {noformat}
> Relative Prefetch
> We found that existing code often executes queries, and then for each result
> node, it reads some additional nodes (satellite data). To better support this
> common pattern, we support relative prefetch. This is done by appending
> "option(prefetch(<relative path>,...))" to the query. If we already know that
> the application will read the child node "jcr:content/comments" and
> "jcr:content/metadata" for each of the results, use:
> {noformat}
> select * from [dam:Asset]
> where contains(*, 'admin')
> option (
> prefetches 100,
> prefetch (
> 'jcr:content/comments',
> 'jcr:content/metadata'
> )
> )
> {noformat}
> We found that often, prefetch of 20 to 100 is faster than a higher prefetch
> count. (This is because the cache might evict the entries if access is too
> far in the future.) We recommend to test with different prefetch options.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
