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 a lot longer in Data1 table (it's actually based on size of blob column)
did I hit some implementation detail (aka all columns data are read till the
one required is returned) ?
should I actually reorder columns based on expected data / size for SQLite ?
Thanks in advance,
M.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
