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:
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:
Mysql 5.7.31 (on local) / aurora-mysql-5-7 - 5.7.12 (on server)
The repository has been constructed in the following manner:
and, fetching the results through
Any help or pointers on how it can be fixed?