Re: [sqlite] bug report: out of memory error for most operations on a large database

2013-01-29 Thread ammon_lymphater
Of Richard Hipp Sent: Monday, January 28, 2013 6:18 AM To: ammon_lympha...@hotmail.com; General Discussion of SQLite Database Cc: Michael Black Subject: Re: [sqlite] bug report: out of memory error for most operations on a large database On Sun, Jan 27, 2013 at 2:57 PM, ammon_lymphater

Re: [sqlite] bug report: out of memory error for most operations on a large database

2013-01-28 Thread ammon_lymphater
: ammon_lymphater [mailto:ammon_lympha...@hotmail.com] Sent: Friday, January 25, 2013 1:40 PM To: 'Michael Black'; 'General Discussion of SQLite Database' Subject: RE: [sqlite] bug report: out of memory error for most operations on a large database To answer your question: - Disk space

Re: [sqlite] bug report: out of memory error for most operations on a large database

2013-01-26 Thread ammon_lymphater
- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of ammon_lymphater Sent: Thursday, January 24, 2013 1:41 PM To: sqlite-users@sqlite.org Subject: [sqlite] bug report: out of memory error for most operations on a large database Summary: except for select count

[sqlite] bug report: out of memory error for most operations on a large database

2013-01-25 Thread ammon_lymphater
Summary: except for select count(*) , all operations on a large table (500m rows/80gb) result in out-of-memory error Details: a. Using SQLite3 ver 3.7.15.2, Windows 7 64 bit AMD(but the error also in 3.6.xx and on other Windows platforms) b. Created a table (schema attached),