I want the latest records from neo4j DB. But during a load test, I find as records increasing the performance of getting the latest records from DB decrease.
Is there any way to index on DATE DESC or property DESC like Informix or Oracle.
As per our requirement, we need the latest records from graph DB.
I have tried to create an index on it but no improvement.
Any help or suggestions really helps.
I think you should be able to add an index that gets used for sorting purposes. Can you check that what you're doing is the same/similar to what's suggested in this article - https://neo4j.com/docs/cypher-manual/current/query-tuning/advanced-example/#advanced-query-tuning-ex...