Re: [sqlite] Trigger slows down application start-up

Dan, On Thu, Oct 31, 2013 at 1:45 AM, Dan Kennedy wrote: > On 10/31/2013 06:20 AM, Igor Korot wrote: >> >> Hi, Clemens et al, >> >> On Wed, Oct 30, 2013 at 1:11 AM, Igor Korot wrote: >>> >>> Clemens, >>> >>> On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot

Re: [sqlite] Trigger slows down application start-up

On 10/31/2013 06:20 AM, Igor Korot wrote: Hi, Clemens et al, On Wed, Oct 30, 2013 at 1:11 AM, Igor Korot wrote: Clemens, On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot wrote: On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch wrote:

Re: [sqlite] Trigger slows down application start-up

Hi, Clemens et al, On Wed, Oct 30, 2013 at 1:11 AM, Igor Korot wrote: > Clemens, > > On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot wrote: >> On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch wrote: >>> Igor Korot wrote: After

Re: [sqlite] Trigger slows down application start-up

On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch wrote: > Igor Korot wrote: >> After those triggers had been created the application start-up time >> significantly increased. >> >> On start-up it opens connection to the database and queries the table >> that is not part of

Re: [sqlite] Trigger slows down application start-up

Igor Korot wrote: > After those triggers had been created the application start-up time > significantly increased. > > On start-up it opens connection to the database and queries the table > that is not part of the trigger. > > Any idea what to look for? Are you creating one connection, or do you

[sqlite] Trigger slows down application start-up

Hi, ALL, I am developing my application on Windows using MSVC 2010 32-bit and test on Win 7 64-bit. Recently I had to create a trigger (actually 2 triggers to populate data in 2 tables). After those triggers had been created the application start-up time significantly increased (debug version