Data fetching is very slow when placing a limit of more than 100

71 views Asked by At

In Orientdb when I am running queries on console, it by default is taking limit as 20. But when I want all my records in my database, I have to put a limit like limit 500 then it's taking a lot of time for 1000 records which is around 6 minutes! Someone please provide me some solution for such a case. And also, can we change the default limit 20 to a desired limit?

0

There are 0 answers