Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-9286

Running query to fetch a node repository takes ~60 secs

    XMLWordPrintableJSON

    Details

      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 already created for it.

      We run the following query to get the desired result:

      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"

      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:

      DocumentNodeStoreBuilder documentNodeStoreBuilder = RDBDocumentNodeStoreBuilder.newRDBDocumentNodeStoreBuilder().setRDBConnection(oakDataSource)
      documentNodeStoreBuilder.createMissingLastRevSeeker()
      documentNodeStoreBuilder.createVersionGCSupport()
      DocumentNodeStore documentNodeStore = documentNodeStoreBuilder.build()
      
      repository = new Jcr(new Oak(documentNodeStore)).createRepository()
      

      and, fetching the results through

      session.getWorkspace().getQueryManager().createQuery(criteria, queryLanguage).execute().getNodes()
      

      Any help or pointers on how it can be fixed?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              vishnuaggarwal23 Vishnu Aggarwal
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: