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

2013-10-31 Thread Dan Kennedy
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 ikoro...@gmail.com wrote: Clemens, On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot ikoro...@gmail.com wrote: On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch clem...@ladisch.de wrote: Igor

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

2013-10-31 Thread Igor Korot
Dan, On Thu, Oct 31, 2013 at 1:45 AM, Dan Kennedy danielk1...@gmail.com 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 ikoro...@gmail.com wrote: Clemens, On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot ikoro...@gmail.com

[sqlite] Trigger slows down application start-up

2013-10-30 Thread Igor Korot
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

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

2013-10-30 Thread Clemens Ladisch
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 open

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

2013-10-30 Thread Igor Korot
On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch clem...@ladisch.de 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 the trigger.

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

2013-10-30 Thread Igor Korot
Hi, Clemens et al, On Wed, Oct 30, 2013 at 1:11 AM, Igor Korot ikoro...@gmail.com wrote: Clemens, On Wed, Oct 30, 2013 at 12:47 AM, Igor Korot ikoro...@gmail.com wrote: On Wed, Oct 30, 2013 at 12:36 AM, Clemens Ladisch clem...@ladisch.de wrote: Igor Korot wrote: After those triggers had