Re: [sqlite] row storage / column order

2011-10-02 Thread yary
Data is stored in pages, and if you have a large blob as the first column, the other data is being pushed out to other pages (I think they are called "internal pages" in the docs). So to read the other data, sqlite has to first read the row's header page, then find & read the page that the other da

Re: [sqlite] row storage / column order

2011-10-02 Thread Mira Suk
_ > Od: "Simon Slavin" > Datum: 02.10.2011 14:01 > > >On 2 Oct 2011, at 12:49pm, Mira Suk wrote: > >> CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, >> Description TEXT) >> vs >> CREATE TABLE [Data2] (Index INTEGER

Re: [sqlite] row storage / column order

2011-10-02 Thread Simon Slavin
On 2 Oct 2011, at 12:49pm, Mira Suk wrote: > CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, > Description TEXT) > vs > CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT, > Data BLOB) > > essentially those tables are same. however accessing the co

[sqlite] row storage / column order

2011-10-02 Thread Mira Suk
Hey everyone,   Imagine tables   CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB, Description TEXT) vs CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT, Data BLOB)   essentially those tables are same. however accessing the column "Description" takes