RE: [sqlite] Sorted index

s@sqlite.org > Subject: Re: [sqlite] Sorted index > > B-Tree indices are in sorted sequence. Just raise an index > on the column. > > [EMAIL PROTECTED] wrote: > > > > > > I would like to maintain a sorted list of ~3000 entries. > > I know that I can c

Re: [sqlite] Sorted index

B-Tree indices are in sorted sequence. Just raise an index on the column. [EMAIL PROTECTED] wrote: I would like to maintain a sorted list of ~3000 entries. I know that I can create a table and the SELECT from it with the ORDER BY clause in order to sort it. However I do not want the overhead

[sqlite] Sorted index

I would like to maintain a sorted list of ~3000 entries. I know that I can create a table and the SELECT from it with the ORDER BY clause in order to sort it. However I do not want the overhead of doing this after adding a new entry. It would be good if I could create an index that was sorted,