Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Stephen Chrzanowski
---Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Jens Alfke > Sent: Wednesday, March 29, 2017 1:14 PM > To: SQLite mailing list > Subject: [sqlite] Questions on big blobs and blob I/O > > I’m thinking of transitioning from e

Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Richard Hipp
On 3/29/17, David Raymond wrote: > Remember to make the blob field the very last field in your table schema, > and avoid "select * from", otherwise you can create performance problems. > The data for a record is stored in the same order as the fields are defined, > and

Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread David Raymond
7 1:14 PM To: SQLite mailing list Subject: [sqlite] Questions on big blobs and blob I/O I’m thinking of transitioning from external to internal storage of large blobs. That is, currently I store these as individual files in a directory next to the SQLite database. But it sounds like today’s new impro

Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Dan Kennedy
On 03/30/2017 12:52 AM, Olivier Mascia wrote: Le 29 mars 2017 à 19:40, Simon Slavin a écrit : Since I’m using WAL, will this db handle keep a snapshot of the time before the blob’s row was deleted, allowing the blob handle to keep working? As Simon said wisely, a word

Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Olivier Mascia
> Le 29 mars 2017 à 19:40, Simon Slavin a écrit : > >> Since I’m using WAL, will this db handle keep a snapshot of the time before >> the blob’s row was deleted, allowing the blob handle to keep working? As Simon said wisely, a word of the developers would clarify this

Re: [sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Simon Slavin
On 29 Mar 2017, at 6:14pm, Jens Alfke wrote: > * Do big blobs cause any performance problems for the db as a whole, like > fragmentation? In particular, is the blob data stored contiguously in the > file? Blobs are stored in the same pages that other values are stored in.

[sqlite] Questions on big blobs and blob I/O

2017-03-29 Thread Jens Alfke
I’m thinking of transitioning from external to internal storage of large blobs. That is, currently I store these as individual files in a directory next to the SQLite database. But it sounds like today’s new improved SQLite is better at managing big blobs, and supports streaming reads; and it