I am pretty new to graph databases so please bear with me.
I was reading that Neo4j stores relations using linked lists and to make search queries faster, it memory maps the contents. Now, in other DBs which have some sort of schema like cassandra, I believe, a sequential query could be really fast as all data is next to each other.
But IIUC, Neo4j is mostly optimised meant for relational queries? If I want to get all the objects of the same type, I would need to go to different memory offsets (causing more page faults) and hence making it slower?
Is my understanding correct or does Neo4j does some additional magic to overcome this as well?
Additionally, as per some of your tutorial videos (which are really amazing), I assume when we require need high perf of sequential reads along with fast relational queries, we should consider using both Neo4j and other DBs together?