Re: Secondary indexes change everything?

2010-12-09 Thread Jonathan Ellis
On Thu, Dec 9, 2010 at 12:16 PM, David Boxenhorn wrote: > What do you mean by, "The included secondary indexes still aren't good at > finding keys for ranges of indexed values, such as " name > 'b' and name < > 'c' "."? > > Do you mean that secondary indexes don't support range queries at all? ht

Re: Secondary indexes change everything?

2010-12-09 Thread David Boxenhorn
What do you mean by, "The included secondary indexes still aren't good at finding keys for ranges of indexed values, such as " name > 'b' and name < 'c' "."? Do you mean that secondary indexes don't support range queries at all? Besides supporting range queries, I see the importance of secondary

Re: Secondary indexes change everything?

2010-12-09 Thread Tyler Hobbs
OPP is not yet obsolete. The included secondary indexes still aren't good at finding keys for ranges of indexed values, such as " name > 'b' and name < 'c' ". This is something that an OPP index would be good at. Of course, you can do something similar with one or more rows, so it's not that big

Re: Secondary indexes change everything?

2010-12-09 Thread David Boxenhorn
- OPP becomes obsolete (OOP is not obsolete!) - primary indexes become obsolete if you ever want to do a range query (which you probably will...), better to assign a random row id Taken together, it's likely that very little will remain of your old database schema... Am I right?

Secondary indexes change everything?

2010-12-09 Thread David Boxenhorn
It seems to me that secondary indexes (new in 0.7) change everything when it comes to data modeling. - OOP becomes obsolete - primary indexes become obsolete if you ever want to do a range query (which you probably will...), better to assign a random row id Taken together, it's likely that very l