Re: [sqlite] Support for clustered indexing (or something similar)?

2008-10-26 Thread Dan
On Oct 27, 2008, at 12:38 PM, Julian Bui wrote: > Thanks for the reply dan. > > You probably don't "need" clustered indexing as such, but this would > be >> >> the kind of case where it provides some advantages. You can get the >> same >> effect in SQLite by including all the data columns in

Re: [sqlite] Support for clustered indexing (or something similar)?

2008-10-26 Thread Julian Bui
Thanks for the reply dan. You probably don't "need" clustered indexing as such, but this would be > > the kind of case where it provides some advantages. You can get the same > effect in SQLite by including all the data columns in your index > definition. > > Unfortunately, because I will be

Re: [sqlite] Support for clustered indexing (or something similar)?

2008-10-26 Thread Dan
On Oct 26, 2008, at 5:15 PM, Julian Bui wrote: > Hi all, > > I have records w/ a timestamp attribute which is not unique and > cannot be > used as a primary key. These records will be inserted according to > timestamp value. From this important fact, I've gathered I need a > clustered >