This is only tangentially related, but what performance do you experience with NoSQL in production with little writes, many (variously sorted and filtered) queries?
I am thinking of fiddling with e-commerce and want to have many different categories each having multiple attributes of different types (not just varchars but also ints and doubles I could sort by)
NoSQL is a much more diverse category than RDBMS, so it will depend on the specific NoSQL DB you are talking about.
The document-store type NoSQL DBs that I've had experience with are absolutely terrible at flexible filtering. RDBMSs are much better for that type of thing.
2 comments
[ 3.1 ms ] story [ 16.9 ms ] threadI am thinking of fiddling with e-commerce and want to have many different categories each having multiple attributes of different types (not just varchars but also ints and doubles I could sort by)
The document-store type NoSQL DBs that I've had experience with are absolutely terrible at flexible filtering. RDBMSs are much better for that type of thing.