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

2014-12-01 Thread Александр Гурьянов
going on. > > > > > > > > > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit > -Forensic Toolkit for SQLite > http://san

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

2014-12-01 Thread Александр Гурьянов
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