On Fri, 12 Sep 2014 17:48:27 -0400, Eric Rubin-Smith <eas....@gmail.com> wrote:
>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? Good question, but I don't have an immediate answer. Perhaps you can set up a quick benchmark with sqlar: http://www.sqlite.org/sqlar Use the -n option to disable compression. > 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? sqlar yields a sqlite3 database, so you can benchmark DELETE performance using SQL. Optimization opportunity: printf "PRAGMA page_size=bytes; VACUUM;\n" \ | sqlite3 benchmark.sqlar >Eric > >References: > >http://sqlite.1065341.n5.nabble.com/Internal-v-External-BLOBs-td15515.html >http://www.sqlite.org/intern-v-extern-blob.html -- Groet, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users