The structure of a record is shown in the graphic at this link which is
from my book SQLite Forensics:
www.sqliteforensics.co.uk/pics/table_leaf_format.png
As long as ALL of the serial types (i.e. all of the cell pointer array) is
held in the main B-tree (i.e. not an overflow page) which unle
Your schema has a major flaw that is addressed in SQLite documentation:
Do not put any fields after blob fields, especially if the content is typically
large. SQLite accesses fields in the order of defintion, so to access your
ANH_PRC_id field, it has to retrieve the 1MB ANP_VALUE blob.
Putting
2 matches
Mail list logo