Re: [sqlite] View update performance (was: Updatable views)

2008-02-14 Thread Steven Fisher
On 14-Feb-2008, at 12:27 PM, Stephen Oberholtzer wrote: > I'd love to know > what frame of mind I was in when I wrote it, because I'm pretty sure I > wouldn't have come up with the name 'MaterializeView' if I had tried > to write the patch today. Altered frames of mind are responsible for both

Re: [sqlite] View update performance (was: Updatable views)

2008-02-14 Thread Stephen Oberholtzer
On Thu, Feb 14, 2008 at 10:17 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Stephen Oberholtzer wrote: > > Stephen, > > FYI, your ticket was fixed on Tuesday by checkin 4782 in case you hadn't > noticed. > > Dennis Cote > Wow, awesome! My claim to fame -- I submitted a patch to an open-source

Re: [sqlite] View update performance (was: Updatable views)

2008-02-14 Thread Dennis Cote
Stephen Oberholtzer wrote: > > If only you'd been around when I'd posted my message! Nobody said > *anything*, so I figured nobody else cared about it. > > I have reposted my mailing list message, with attachments, here: > http://www.sqlite.org/cvstrac/tktview?tn=2938 > > I have not updated the

Re: [sqlite] View update performance (was: Updatable views)

2008-02-12 Thread Dennis Cote
Stephen Oberholtzer wrote: > > If only you'd been around when I'd posted my message! Nobody said > *anything*, so I figured nobody else cared about it. > I have been around for quite some time, but I don't recall your message. However, I do occasionally take a vacation, or get busy and just

Re: [sqlite] View update performance (was: Updatable views)

2008-02-11 Thread Stephen Oberholtzer
On Feb 11, 2008 1:53 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > > Stephen Oberholtzer wrote: > > I should note that there's a gross inefficiency when using triggers to > > handle updates or deletes against views; SQLite does the equivalent of > > this: > > > > For UPDATE ... WHERE , SQLite