[sqlite] Xcode 4.2 warning in 3.7.10 about long long

This is about the warning discussed here: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036221.html It is not a warning from Clang's analyzer. It's just a standard warning. Since I like to treat warnings as errors in all my projects, I can't currently build 3.7.10. I'

Re: [sqlite] Trigger for incrementing a column is slow

On Feb 3, 2011, at 10:35 PM, Dan Kennedy wrote: > Do you have a test program that we can use to reproduce this phenomenon? > > Dan. Here is a complete program: http://pastie.org/pastes/1527560 Set USE_TRIGGER to see the trigger version. Thanks, Kevin _

Re: [sqlite] Trigger for incrementing a column is slow

On Feb 3, 2011, at 2:27 PM, Jim Wilcoxson wrote: > On Thu, Feb 3, 2011 at 5:07 PM, Kevin Wojniak wrote: > >> >> On Feb 3, 2011, at 11:41 AM, Petite Abeille wrote: >> >>> On Feb 3, 2011, at 6:53 PM, Kevin Wojniak wrote: >>> >>>> The trigg

Re: [sqlite] Trigger for incrementing a column is slow

On Feb 3, 2011, at 11:41 AM, Petite Abeille wrote: > On Feb 3, 2011, at 6:53 PM, Kevin Wojniak wrote: > >> The trigger is ran once via sqlite3_exec(); > > Hmm... you mean the trigger is run every single time you perform an insert, > no? Yes. I should say the trigge

[sqlite] Trigger for incrementing a column is slow

I've got a tree structure where whenever I insert a new node, I want its parent entry's number of children to increment. I figured a trigger would be great for this, however it is very slow compared to just a standard UPDATE manually ran after the INSERT. Here is the table: CREATE TABLE root (r