That's great thank you very much. ----- Ursprüngliche Mail ---- Von: [EMAIL PROTECTED] An: sqlite-users@sqlite.org; Martin Pfeifle <[EMAIL PROTECTED]> Gesendet: Mittwoch, den 5. April 2006, 23:09:25 Uhr Betreff: Re: [sqlite] primary key and physical data organization
Martin Pfeifle <[EMAIL PROTECTED]> wrote: > Hi, > Assume I have a table containing an integer primary key. As far as I know, > this value is identical to the ROWID, right? Correct > How does SQLite organize the data within the file? > Does it try to organize the data on the pages according to the primary key > (=ROWID) or according to the insertion order of the records? > Can anyone explain that to me? Entries or ordered by ROWID. -- D. Richard Hipp <[EMAIL PROTECTED]>
