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
3 matches
Mail list logo