Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Dan Kennedy
On 09/15/2014 06:19 PM, Dominique Devienne wrote: On Mon, Sep 15, 2014 at 12:29 PM, Dan Kennedy wrote: On 09/15/2014 03:18 PM, Dominique Devienne wrote: On Fri, Sep 12, 2014 at 11:48 PM, Eric Rubin-Smith wrote: Looking at the sqlite web site and

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Eric Rubin-Smith
Dominique Devienne 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

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Simon Slavin
On 15 Sep 2014, at 1:23pm, Dominique Devienne wrote: > On Mon, Sep 15, 2014 at 1:59 PM, Simon Slavin wrote: > >> It just rewrites >> bytes wherever the existing row is on disk, > > Then how is this transaction safe? I might not be reading the doc

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Dominique Devienne
On Mon, Sep 15, 2014 at 1:59 PM, Simon Slavin wrote: > On 15 Sep 2014, at 12:19pm, Dominique Devienne > wrote: > > On Mon, Sep 15, 2014 at 12:29 PM, Dan Kennedy > wrote: > >> On 09/15/2014 03:18 PM, Dominique Devienne wrote: >

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Simon Slavin
On 15 Sep 2014, at 12:19pm, Dominique Devienne wrote: > On Mon, Sep 15, 2014 at 12:29 PM, Dan Kennedy wrote: > >> On 09/15/2014 03:18 PM, Dominique Devienne wrote: >> >>> whenever >>> you >>> want to update a single byte of a blob, you must rewrite

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Dominique Devienne
On Mon, Sep 15, 2014 at 12:29 PM, Dan Kennedy wrote: > On 09/15/2014 03:18 PM, Dominique Devienne wrote: > >> On Fri, Sep 12, 2014 at 11:48 PM, Eric Rubin-Smith >> wrote: >> >> Looking at the sqlite web site and mailing lists shows that the SQLite >>>

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Dan Kennedy
On 09/15/2014 03:18 PM, Dominique Devienne wrote: On Fri, Sep 12, 2014 at 11:48 PM, Eric Rubin-Smith 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

Re: [sqlite] write internal blob vs external file

2014-09-15 Thread Dominique Devienne
On Fri, Sep 12, 2014 at 11:48 PM, Eric Rubin-Smith 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

Re: [sqlite] write internal blob vs external file

2014-09-12 Thread Kees Nuyt
On Fri, 12 Sep 2014 17:48:27 -0400, Eric Rubin-Smith 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

Re: [sqlite] write internal blob vs external file

2014-09-12 Thread Simon Slavin
On 12 Sep 2014, at 10:48pm, Eric Rubin-Smith 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

Re: [sqlite] write internal blob vs external file

2014-09-12 Thread Richard Hipp
On Fri, Sep 12, 2014 at 5:48 PM, Eric Rubin-Smith 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

[sqlite] write internal blob vs external file

2014-09-12 Thread Eric Rubin-Smith
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