Looking at the sqlite web site and mailing lists shows that the SQLite team has taken a stab at answering the question, "is it faster to read a blob out of sqlite or out of a file?". See the links below.
Does the team have analogous guidance regarding write speeds? I'm also interested in the delete path. It seems like SQLite doesn't have much hope of competing with a native filesystem unlink(2) call to delete a file that is many gigabytes long, for example. Is that right? Eric References: http://sqlite.1065341.n5.nabble.com/Internal-v-External-BLOBs-td15515.html http://www.sqlite.org/intern-v-extern-blob.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users