On Thu, 12 Oct 2017 19:32:53 -0700 (MST), Fiona <cxfhn1...@gmail.com> wrote:
> schema: > <http://sqlite.1065341.n5.nabble.com/file/t8403/schema.jpg> Not related to your problem, just a hint: Swapping the columns tile_data and tile_id may improve performance significantly, especially if the BLOB can get bigger than a database page. Original: CREATE TABLE images ( tile_data BLOB , tile_id VARCHAR(256) NOT NULL , PRIMARY KEY (tile_id)); -- might be slow Improved: CREATE TABLE images ( tile_id VARCHAR(256) NOT NULL , tile_data BLOB , PRIMARY KEY (tile_id)); -- could be faster -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
