[jira] [Created] (OAK-9286) Running query to fetch a node repository takes ~60 secs

["Vishnu Aggarwal (Jira)" <ji...@apache.org>]

Vishnu Aggarwal created OAK-9286:
------------------------------------

             Summary: 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


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?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)