[odb-users] "threads-sqlite" test case takes an extraordinary long time to execute

[Andrew Cunningham]

I am using SQLite "sqlite-amalgamation-3120200" 
The only additional flag when compiling SQLite is "SQLITE_ENABLE_UNLOCK_NOTIFY" and "LIBODB_SQLITE_HAVE_UNLOCK_NOTIFY" in libodbsqlite

It's clearly some odd interaction with the internal SQLite thread-safe operations. 
This is reproducible on multiple machines and VS versions.
Since you can't reproduce I will have to dig into the Intel Amplifier results a bit more to try and see what is happening.



> -----Original Message-----
> From: Boris Kolpackov [mailto:boris at codesynthesis.com]
> Sent: Wednesday, July 13, 2016 9:01 AM
> To: Andrew Cunningham <odb at a-cunningham.com>
> Cc: odb-users at codesynthesis.com
> Subject: Re: [odb-users] "threads-sqlite" test case takes an extraordinary long
> time to execute
> 
> Hi Andrew,
> 
> Andrew Cunningham <odb at a-cunningham.com> writes:
> 
> > I was running the "threads-sqlite-vc12" testcase  (Windows x64/VS
> > 2013) and it takes a very long time to complete ( it does finally
> > finish). On the order of 45 minutes on a fast-ish machine.
> 
> It takes a few minutes on our test VM (Windows 7) and doesn't seem to differ
> much from VC version to version. Is there perhaps something special you did
> when building SQLite?
> 
> Boris