Re: [sqlite] Sqlite uses a lot of memory during a delete operation

On Mon, Sep 7, 2009 at 12:28 PM, P Kishor wrote: > Find out if the DELETEion is chewing up the memory or the SELECTion. Try > > SELECT * FROM old_conns WHERE "end" >= strftime('%s', 'now', '-7 days'); > > If the above is quick, you can simply create a new table with that, >

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

Tried that, it didn't help. On Mon, Sep 7, 2009 at 11:40 AM, Simon Slavin <slav...@hearsay.demon.co.uk>wrote: > > On 7 Sep 2009, at 4:01pm, Benjamin Rutt wrote: > > > Good idea. Tried that, though, and it didn't help - the process > > still grew > > and grew in

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

> > You're doing this on 68 million rows. While it probably shouldn't > give an error in this way, I can imagine various things that might > cause it. > > To help with debugging, and also as a suggested fix until the problem > can be investigated, could you pre-calculate your 'strftime' value, >

[sqlite] Sqlite uses a lot of memory during a delete operation

o see it succeed. Is there any obvious explanation for this? Any administrative controls I can use to prevent it from happening? Thanks. -- Benjamin Rutt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users