Re:MongoDB gotchas for the unaware user
by msy on Thursday December 23, 2010 @08:59AM
(#2034376)
Another small one I'd point out: You can't sort large sets on fields that aren't indexed. It's not just slow, mongo flat out refuses to do it.
[ Parent
| on HN ]
Re:MongoDB gotchas for the unaware user
by piotrSikora on Thursday December 23, 2010 @09:03AM
(#2034383)
This is actually awesome feature! AppEngine's Datastore requires this as well.
I really wish that PostgreSQL (and other SQL databases) would allow one to enforce such policy, it's a lifesaver.
Agreed. I wish normal SQL dbs would implement a mode where index misses result in errors unless they contain some sort of opt in text.
Re:MongoDB gotchas for the unaware user
by eldenbishop on Thursday December 23, 2010 @08:00PM
(#2036316)
Mongo servers can be run in a mode that rejects the query with an error if it would result in a row scan. Very useful for safely avoiding bad queries slamming your server.