On Fri, Sep 12, 2014 at 5:48 PM, 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? > > 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? > The fact that SQLite is faster at reading was originally discovered by the Adobe Lightroom developers and was surprising to the team. We have not looked into write performance. Why don't you do the measurements and report back? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
