Re: [sqlite] EXTERNAL: In memory database and locking.

2010-09-09 Thread Hemant Shah
: From: Black, Michael (IS) Subject: Re: [sqlite] EXTERNAL: In memory database and locking. To: "General Discussion of SQLite Database" Date: Thursday, September 9, 2010, 7:48 AM Have you considered doing your cleanup during a trigger? I assume you're already using transactions for y

Re: [sqlite] EXTERNAL: In memory database and locking.

2010-09-09 Thread Black, Michael (IS)
Have you considered doing your cleanup during a trigger? I assume you're already using transactions for your inserts. I wouldn't think it would be much slower doing it every insert as you'd be deleting a much smaller set every time. This is really a LOT faster if you just hash your info and then