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 expert.
You might post the text result when you run an explain on the slow sql http://sqlite.org/lang_explain.html It will help understand what's happening "underneath"
