Hi All,
I am facing slowness in the local AEM authoring instance(1 hour to load author instance) and getting the below message in
error.log file
---------------
31.01.2017 00:03:49.461 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id /* oak-internal */, path=*, property=[jcr:uuid=[9400a0e8-5d7e-36ad-bb8a-2ce8783a9281]]); consider creating an index or changing the query
31.01.2017 00:03:49.541 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 2000 nodes with filter Filter(query=SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id /* oak-internal */, path=*, property=[jcr:uuid=[9400a0e8-5d7e-36ad-bb8a-2ce8783a9281]]); consider creating an index or changing the query
31.01.2017 00:03:49.624 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 3000 nodes with filter Filter(query=SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id /* oak-internal */, path=*, property=[jcr:uuid=[9400a0e8-5d7e-36ad-bb8a-2ce8783a9281]]); consider creating an index or changing the query
.
.
.
31.01.2017 00:11:31.982 *WARN* [FelixStartLevel] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 517000 nodes with filter Filter(query=SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id /* oak-internal */, path=*, property=[jcr:uuid=[e2484592-c2a2-3917-9040-a5432d4c9d2c]]); consider creating an index or changing the query
stderr.log
----------
Low-memory action set to fork
Using 32bit VM settings, min.heap=768MB, min permgen=192MB, default fork arguments=[-Xmx768m, -XX:MaxPermSize=192m]
**** WARNING: insufficent heap memory ******************************************
The JVM reports 742 MB but we recommend at least 768 MB +/- 20
Use your JVM's heap size option (like -Xmx768M) to set that size.
ENV: AEM 6.1
Please suggest me if any configuration change require to improve the performance.
Thanks in Advance.
