Re: [sqlite] Suggestions for optimizing delete

2006-02-27 Thread drh
"Brett Wilson" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm working on using sqlite for Firefox's bookmarks and history > system. We need to expire history older than N days when the browser > shuts down. It's currently slower than I would like and I'd appreciate > any tricks you might be able to

Re: [sqlite] Suggestions for optimizing delete

2006-02-27 Thread Jay Sprenkle
On 2/27/06, Brett Wilson <[EMAIL PROTECTED]> wrote: > > I tried some other things like creating a trigger that sets a flag in > moz_history when a visit has been deleted so we only have to check > those items, but it still seems slow. Can anybody offer any insight on > this? I'm not really a SQL

[sqlite] Suggestions for optimizing delete

2006-02-27 Thread Brett Wilson
Hi, I'm working on using sqlite for Firefox's bookmarks and history system. We need to expire history older than N days when the browser shuts down. It's currently slower than I would like and I'd appreciate any tricks you might be able to suggest. Database layout: We have a table of URLs and