[sqlite] How would sqlite read this from disk?

[Mark Hamburg]

> On Oct 29, 2015, at 12:24 PM, Richard Hipp <drh at sqlite.org> wrote:
> 
> If you do have large BLOBs or strings, SQLite handles this best if the
> large blob/string is stored in a table by itself and then linked into
> other tables using an integer primary key.  For example:
> 
>   CREATE TABLE BigBlobTab (
>       blobid INTEGER PRIMARY KEY,
>       content BLOB -- big BLOB or text field.
>   );
>   CREATE TABLE OtherStuff (
>       field1 VARCHAR(10),
>       field2 FLOAT,
>       field3 BOOLEAN,
>       blobid INT REFERENCES BigBlobTab
>   );

Will SQLite rewrite the whole row if you just change field2 from one float to 
another?

Mark