Hi, Maksim,
Others with more knowledge than I have given great advice regarding placing
your blob as the *last* table column, and about looking at cache size and
page size.
I wondered about three things:
1) Might there be further performance gains by placing the blobs in a
separate table?
E.g.
CREATE TABLE myBlobs (
id INTEGER PRIMARY KEY REFERENCES global (id),
value BLOB
);
Then (if you haven't rebuilt a new db, and perhaps only once ever) run
VACUUM and ANALYZE.
2) Any chance your app might be faster with your blobs in files instead of
in the db? Is the following info useful?
https://www.sqlite.org/intern-v-extern-blob.html
3) Are you truly certain the solution against which you compared sqlite did
not have the data in system cache?
Don't know if this is helpful,
Donald G.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
