[sqlite] INTEGRITY_CHECK consumes entire system memory

2016-05-19 Thread Detlef Golze
: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Markus Ecker Sent: Tuesday, May 17, 2016 3:56 PM To: sqlite-users at mailinglists.sqlite.org Subject: [sqlite] INTEGRITY_CHECK consumes entire system memory Hello together! I am

[sqlite] INTEGRITY_CHECK consumes entire system memory

2016-05-18 Thread Jeremy Nicoll
On Tue, 17 May 2016, at 14:55, Markus Ecker wrote: > PRAGMA mmap_size=0; That, according to the documentation, means "turn off memory-mapping" PROVIDED the database isn't in use already with memory-mapping active. So, is the database soley in use by your integrity check when this happens? What

[sqlite] INTEGRITY_CHECK consumes entire system memory

2016-05-18 Thread Richard Hipp
On 5/17/16, Markus Ecker wrote: > Hello together! > > I am struggling with a memory issue of SQLite and therefore searching for > help. The database of our product has about 70GB of data. When I call the > "PRAGMA integrity_check" method, the memory consumption of my system > continuously

[sqlite] INTEGRITY_CHECK consumes entire system memory

2016-05-17 Thread Markus Ecker
Hello together! I am struggling with a memory issue of SQLite and therefore searching for help. The database of our product has about 70GB of data. When I call the "PRAGMA integrity_check" method, the memory consumption of my system continuously increases until all of my 16GB of RAM are used.