> (2) Even if the row is all on one page, SQLite has to compute sizes of > all prior columns and add those sizes together in order to find the > offset to a particular column in that row. The fewer prior columns > there are, the less work is involved for this step.
I?m curious: how much work are we talking about here? If I have 99 INTEGER fields followed by a BLOB one, to access the BLOB field, does SQLite need to compute the size of each previous INTEGER field first? -Pol ________________________________ Pol-Online info at pol-online.net (mailto:info at pol-online.net)
