Re: [sqlite] Much unused space in sqlite3 database when using blobs

Richard, Paul thanks! You help me so much. Omitting WITHOUT ROWID do the trick. 2014-12-02 3:04 GMT+07:00 Paul Sanderson : > Further to Richards comment the formula to determine when a record > overflows into a page file is given in section 1.5 of the file format >

Re: [sqlite] Much unused space in sqlite3 database when using blobs

Further to Richards comment the formula to determine when a record overflows into a page file is given in section 1.5 of the file format doc http://www.sqlite.org/fileformat.html The relevant section states: The amount of payload that spills onto overflow pages also depends on the page type.

Re: [sqlite] Much unused space in sqlite3 database when using blobs

On Sun, Nov 30, 2014 at 11:06 PM, Александр Гурьянов wrote: > Hi. Hi. I am writing an app that stores some blobs in sqlite3 database. My > question is about disk space usage. > For analyst i use sqlite_analyzer. > > My database is created with this script: > > PRAGMA

[sqlite] Much unused space in sqlite3 database when using blobs

Hi. Hi. I am writing an app that stores some blobs in sqlite3 database. My question is about disk space usage. For analyst i use sqlite_analyzer. My database is created with this script: PRAGMA page_size = 512; PRAGMA synchronous = OFF; PRAGMA journal_mode = MEMORY; begin; create table

[sqlite] undesirable output from ~/.sqliterc processing

Version: 3.8.7.1 2014-10-29 13:59:56 3b7b72c4685aa5cf5e675c2c47ebec10d9704221 I added a single line to my .sqliterc file to load pcre like so: .load /usr/lib/sqlite3/pcre.so Now there's annoying output on ever run: $ sqlite3 test.db .schema -- Loading resources from /home/zen/.sqliterc CREATE