Re: AW: [sqlite] primary key and physical data organization

Martin Pfeifle wrote: Thanks, If we look at a B+-tree, all records are stored at the leaf level and form at least a logical list. But what happens, if we insert new records which do not fit on the corresponding leaf page any more. Assume this page has to be split. Where is the newly created p

Re: AW: [sqlite] primary key and physical data organization

Martin Pfeifle <[EMAIL PROTECTED]> wrote: > Our goal is that all records are physically clustered according to their RO= > WID. > In order to achieve this goal, does it make sense to reorganize a table by = > for instance a command like > "insert into reorganized_table > select * from original_tabl

AW: [sqlite] primary key and physical data organization

Uhr Betreff: Re: [sqlite] primary key and physical data organization Martin Pfeifle 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? >How does SQLite organize the data within the file? >Does it try to

Re: [sqlite] primary key and physical data organization

Martin Pfeifle 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? 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

AW: [sqlite] primary key and physical data organization

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 Pfei

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 th

[sqlite] primary key and physical data organization

Hi, Assume I have a table containing an integer primary key. As far as I know, this value is identical to the ROWID, right? 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