On May 30, 2017 10:07:45 AM EDT, Thomas Flemming <t...@qvgps.com> wrote:
>Style.Id doesn't need to be LONG, you're right. I changed it but it >doesn't >make a difference. >Pois.Id need to be LONG because the source for this column is really >containing 64-bit values Integers in SQLite are of variable size; if an 8-byte size is required, it will scale accordingly. Specifying LONG will not yield an integer affinity like specifying INTEGER would, and for primary keys is not as efficient because the column is not an alias for rowid if you specify LONG. In short, you should always use INTEGER PRIMARY KEY if the column is whole numbers, regardless of size. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users