CODEWITHSUNDEEP
databasemongodbdatabase-designnosql
Aishwary Tiwari
Aishwary Tiwari

Reputation: 1663

Which Database to prefer for tree traversal?

I am trying to create a smart interface where when user enter a street name, they get suggestion for locality,city(all cities containing same street name), state, country etc.

Right now I am trying to make it work on MongoDB, but have doubt on its performance. I will appreciate any suggestion on, how to use MongoDB effectively or other databases better suitable for this purpose. i`m using Nosql as we need high efficiency.

Note. above example is hypothetical one, i need for multiple purpose, where connection can be complex.

Upvotes: 1

Views: 237

Answers (1)

albattran
albattran

Reputation: 1907

NoSQL databases are not the most efficient when you have relationships, they are most useful for having retrieval by key and denormalized databases, if you have relations in your data model the most efficient is a relational database (SQL)

Upvotes: 2

Related Questions