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
> doc
>
> http://www.sqlite.org/f
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. For
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 page_size = 512;
> PRAGMA syn
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 grid_blobs
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 T
5 matches
Mail list logo