When querying the table be sure to put the indexed column(s) in the ORDER BY clause though - otherwise the index won't do you any good. :)
-T > -----Original Message----- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 05, 2007 9:20 AM > To: sqlite-users@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 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, and then when I > > add a new entry to the table it would automatically be > inserted in the index at > > the correct position. > > Is this possibe? > > If not, can anyone suggest any other solution, baring in > mind that RAM memory > > needs to be kep to a minimum? > > > > Thanks > > Clive > > > > > > > > > -------------------------------------------------------------- > --------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > > -------------------------------------------------------------- > --------------- > > > > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
