I have seen that AGE is good for graph projects but while doing something I was getting few performance issues with some Queries. Now I really want to really optimize the Apache age in order to minimize the usage of the resource and increase the query performance.
In this regard, I want to know some good techniques to increase and optimize the performance using Apache age. Also, are there any things to be avoided while optimizing the Age's performance?
There are Various ways to do this There is complete Blog On this source to blog
You can check this out When question is about performance of db queries the first thing is to use proper indexing. Second do not make extra db calls and make sure if you are running more than one query at a time then run in parallel to reduce cost.
Always use limit to fetch number of results let suppose you have 1000 record do not fetch all record at once Apply limit.
