We just rewrote our app from a Postgres backend to a Redis backend. The main difference I see with using NoSQL vs traditional SQL is that you massage the data d

We just rewrote our app from a Postgres backend to a Redis backend. The main difference I see with using NoSQL vs traditional SQL is that you massage the data during insert time so when you goto to look it up later it's pretty much already in the form you need it. This makes lookups super fast, regardless of whether you're paging or not. I can honestly say I'll never look back. Traditional SQL had a nice run but the incredible gains in simplicity and performance with nosql are indisputable - especially performance. Case in point: In our initial testing it looks like the Redis setup will be able to support approx 10,000 accounts on one modest dedicated server vs about 100-200 accounts using Postgres.