Geek Answers Handbook

NoSQL database with high read rates (write to write is not significant)?

I work on a real-time website using Nodejs . I am currently using Redis because I need high performance for read access. Access to the record is not very important for my use.

In addition, Redis does not have a search query language. So, I create my indexes manually, and I use some joins / intersections / ... to find some values.

I think it will be easier to use MongoDB with an integrated search engine and ORM-like ( Mongoose , for example). The problem is that I'm not sure if MongoDB is the best choice for my use.

What are your tips regarding the NoSQL database I need? Radish? CouchDB ? MongoDB? Cassandra ? and etc.

I repeat: I want to have real good performance for read and search access (write access is not significant), the simplest (orm-like search system? Etc.).)

Thanks.

+8
database mongodb nosql redis
source share
3 answers

I believe that redis would be the best solution for the following reasons.

  • You need quick read access, and redis provides the fastest solution, since the keys are in memory, if not most.

  • Although mongodb is easier to query in the general case, your problem domain is narrow, and once you decide how you want to query the data, you can set the correct data structures and indexes.

+4
source share

I would say that Redis is well suited for your database, and you should look at something like Solr or elasticsearch to provide a search.

+1
source share

CouchDB will perform better in heavy recording environments. I do not use it. MongoDB will work better with a read heavy environment.

For search and indexing: MongoDB will require a separate index for each of your search criteria to improve performance (at least this is what I remember).

The correct index is important in MongoDB. And does not join!

Here are some links you can go through:

http://www.mongodb.org/display/DOCS/Comparing+Mongo+DB+and+Couch+DB

http://www.snailinaturtleneck.com/blog/2009/06/29/couchdb-vs-mongodb-benchmark/

http://kkovacs.eu/cassandra-vs-mongodb-vs-couchdb-vs-redis

Hope this helps you find the right db

Good luck

0
source share

More articles:


All Articles