[
https://issues.apache.org/jira/browse/OAK-9286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vishnu Aggarwal updated OAK-9286:
---------------------------------
Description:
We have an oak repository set up as the following structure under the root node
with 4 different node types namely. One of the nodeTypes (cm:media) has ~10K
nodes created for it.
We run the following query to get the desired result:
{code:java}
SELECT * FROM [cm:mediaFile] as node WHERE ISDESCENDANTNODE(node,
"/mediafiles") AND LENGTH(node.[cm:oldId]) > 0 AND node.[cm:oldId] =
"c6a958ef-2060-4599-ac72-d0a96d062180"{code}
While running the application on local machine, the query returns the result in
~5 seconds while running the same query on the server, it takes around ~60
seconds.
The stack being used is:
Grails 3.3.5
Java 8
Mysql 5.7.31 (on local) / aurora-mysql-5-7 - 5.7.12 (on server)
OAK 1.9.8
The repository has been constructed in the following manner:
{code:java}
DocumentNodeStoreBuilder documentNodeStoreBuilder =
RDBDocumentNodeStoreBuilder.newRDBDocumentNodeStoreBuilder().setRDBConnection(actualDataSource)
documentNodeStoreBuilder.createMissingLastRevSeeker()
documentNodeStoreBuilder.createVersionGCSupport()
DocumentNodeStore documentNodeStore = documentNodeStoreBuilder.build()
repository = new Jcr(new Oak(documentNodeStore)).createRepository()
{code}
and, fetching the results through
{code:java}
session.getWorkspace().getQueryManager().createQuery(criteria,
queryLanguage).execute().getNodes()
{code}
Any help or pointers on how it can be fixed?
was:
We have an oak repository set up as the following structure under the root node
with 4 different node types namely. One of the nodeTypes (cm:media) has ~10K
nodes created for it.
We run the following query to get the desired result:
{code:java}
SELECT * FROM [cm:mediaFile] as node WHERE ISDESCENDANTNODE(node,
"/mediafiles") AND LENGTH(node.[cm:oldUUID]) > 0 AND node.[cm:oldUUID] =
"c6a958ef-2060-4599-ac72-d0a96d062180"{code}
While running the application on local machine, the query returns the result in
~5 seconds while running the same query on the server, it takes around ~60
seconds.
The stack being used is:
Grails 3.3.5
Java 8
Mysql 5.7.31 (on local) / aurora-mysql-5-7 - 5.7.12 (on server)
OAK 1.9.8
The repository has been constructed in the following manner:
{code:java}
DocumentNodeStoreBuilder documentNodeStoreBuilder =
RDBDocumentNodeStoreBuilder.newRDBDocumentNodeStoreBuilder().setRDBConnection(actualDataSource)
documentNodeStoreBuilder.createMissingLastRevSeeker()
documentNodeStoreBuilder.createVersionGCSupport()
DocumentNodeStore documentNodeStore = documentNodeStoreBuilder.build()
repository = new Jcr(new Oak(documentNodeStore)).createRepository()
{code}
and, fetching the results through
{code:java}
session.getWorkspace().getQueryManager().createQuery(criteria,
queryLanguage).execute().getNodes()
{code}
Any help or pointers on how it can be fixed?
> Running query to fetch a node repository takes ~60 secs
> -------------------------------------------------------
>
> Key: OAK-9286
> URL: https://issues.apache.org/jira/browse/OAK-9286
> Project: Jackrabbit Oak
> Issue Type: Bug
> Reporter: Vishnu Aggarwal
> Priority: Critical
>
> We have an oak repository set up as the following structure under the root
> node with 4 different node types namely. One of the nodeTypes (cm:media) has
> ~10K nodes created for it.
> We run the following query to get the desired result:
> {code:java}
> SELECT * FROM [cm:mediaFile] as node WHERE ISDESCENDANTNODE(node,
> "/mediafiles") AND LENGTH(node.[cm:oldId]) > 0 AND node.[cm:oldId] =
> "c6a958ef-2060-4599-ac72-d0a96d062180"{code}
> While running the application on local machine, the query returns the result
> in ~5 seconds while running the same query on the server, it takes around ~60
> seconds.
>
> The stack being used is:
> Grails 3.3.5
> Java 8
> Mysql 5.7.31 (on local) / aurora-mysql-5-7 - 5.7.12 (on server)
> OAK 1.9.8
>
> The repository has been constructed in the following manner:
> {code:java}
> DocumentNodeStoreBuilder documentNodeStoreBuilder =
> RDBDocumentNodeStoreBuilder.newRDBDocumentNodeStoreBuilder().setRDBConnection(actualDataSource)
> documentNodeStoreBuilder.createMissingLastRevSeeker()
> documentNodeStoreBuilder.createVersionGCSupport()
> DocumentNodeStore documentNodeStore = documentNodeStoreBuilder.build()
> repository = new Jcr(new Oak(documentNodeStore)).createRepository()
> {code}
> and, fetching the results through
> {code:java}
> session.getWorkspace().getQueryManager().createQuery(criteria,
> queryLanguage).execute().getNodes()
> {code}
> Any help or pointers on how it can be fixed?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
