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

Andrew Cunningham odb at a-cunningham.com
Thu Jul 14 12:52:15 EDT 2016

With my build of SQLite , using all your SQLite #defines, the test ran in
1243.1s. ( not quite as long as I originally said, but still unexpectedly

It's pretty clear based on profiling that the time is spent in
synchronization objects waiting on disk operations to complete.

I changed the Journal mode

"PRAGMA journal_mode = MEMORY"

and the execution time was 342s (4x faster). Still surprisingly long. The
CPU is idle nearly 95% of the time.

On Thu, Jul 14, 2016 at 8:52 AM, Boris Kolpackov <boris at codesynthesis.com>

> Hi Andrew,
> Andrew Cunningham <Andrew.Cunningham at esi-group.com> writes:
> > I am using SQLite "sqlite-amalgamation-3120200"
> I checked and we are (still) using 3.7.5. You can try that in case
> SQLite folks broke something.
> > The only additional flag when compiling SQLite is
> We have quite a few more defines. Check SQLite the project files in the
> etc/ directory in libodb-sqlite.
> Boris

More information about the odb-users mailing list