Peter is right. You should really take some significant time to analyze not only the current needs of your application, but future needs as well. Going the NoSQL route isn't as cut and dry as just picking one. Many of the implementations are designed to solve different problems. Some things to consider before making a final decision would be:
* As peter said, referential integrity
* The ratio of reads vs writes to your data store. Some nosql solutions are designed for higher volume writes or reads
* How important data consistency is to your application, if you require a clustered data store
* Transactions. What operations will require them, and do you need them.
* The rate of growth your data, or if your data sets have a finite upper bound or not. Are you expecting simple linear growth, or some rate of exponential growth. In my experience, catching up to growth you aren't prepared for is the most difficult of problems in a growing company.
I've learned in my experience that rdbms and nosql has never been a 1 stop shop. I've tended to require specific data store implementations to solve specific problems, thus resulting in a hybrid. My only real advice is to not take advice from people who are religiously devoted to one solution. Do your research, play around with solutions and do your own benchmarks if you have time. And don't over complicate things if you don't have to. Like Peter said, do you really need more than a simple RDBMS?
Jordon
On Oct 19, 2011, at 2:15 AM, Peter Ledbrook wrote:
>> I'm working at a project that I will have a table with many rows and I need
>> perfomace to query this table. I'm considering using a NoSQL database +
>> Grails. Waht do you suggest?
>
> That you check whether a standard relational database will satisfy
> your performance needs. There are no shortcuts here I'm afraid. Also,
> you need to decide whether you need referential integrity or not.
> Also, how consistent does your database need to be? For example, if
> you enable fsync in MongoDB, the performance apparently drops
> significantly.
>
> Peter
>
> --
> Peter Ledbrook
> Grails Advocate
> SpringSource - A Division of VMware
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>
http://xircles.codehaus.org/manage_email>
>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
Locked
