On 8/31/18, t...@qvgps.com <t...@qvgps.com> wrote: > > So is it just the value of the primary key controlling in which page the > row is stored?
The page on which content is stored is determine (approximately) by the value of the ROWID, which is the same as the INTEGER PRIMARY KEY as long as you declare the primary key to be of type "INTEGER". If you declare the PRIMARY KEY to be something other than "INTEGER" (for example: "INT" or "LONG") then the ROWID and the primary key are different and the primary key has no influence over where the content is stored. Or if you create a WITHOUT ROWID table, then the PRIMARY KEY is the value that determines (approximately) on which page the content is stored. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
