>> Swapping the columns tile_data and tile_id may improve performance significantly, especially if the BLOB can get bigger than a database page.
Thanks for your advice, could you please explain more why is that? The primary key is not change at all, what exectly causes the improvement? -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
