The operating system is Windows7 x64 Ultimate, 4 Gb RAM I have not specified any PRAGMAs when run sqlite3.exe. The program was launched normally (in non-elevated mode). The database file is located on the local disk (C:) with a 95 GB of free space
Here's how I launch this: C:\temp\131418>sqlite3.exe problem.db SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> delete from differential_parts_temp where plan_id='bf43c9ae-d681-4f2a-be19-0e0426db2b43'; Error: out of memory sqlite> It works for about 10 minutes on my not loaded i5-2400 3.1Ghz, reaching by this moment about 1.7Gb of memory in task manager, and then fails. On Wed, Oct 17, 2012 at 8:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 17 Oct 2012, at 4:58pm, Ivan P <iva...@cloudberrylab.com> wrote: > > > Why the DELETE statement can eat so much memory? > > Because it doesn't delete each one row singly, doing all the file updates > that are needed to delete that row, then move on to the next row. If it > did it would take an extremely long time to operate. Nevertheless it is > definitely not meant to ever crash in the way you're seeing. It is meant > to realise when its available memory is full, flush changes to disk, then > carry on. > > > SQLite Expert shows the following DB properties: > > Some of these (e.g foreign_keys) are not properties of the database, but > of the connection that SQLite Expert has opened to it, so they are not > relevant to anything you've been doing in the shell tool. So instead we > ask the following questions: > > Which version of Windows are you running ? Did you specify any PRAGMAs in > the shell tool ? Are you opening the file on a local disk or across a file > sharing connection ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users