[odb-users] Timeout and Concurrency issues

[Erez Pics]

Hi Boris,

We are using ODB for SQLite on both Mac and Windows, we recently
changed our objects to work more concurrently using a write several
behind caches each dedicated to DB entity group, this in turn
increases the load on the database.

On windows things seem to work fine but on Mac we get many timeout
exceptions and objects are not persisted properly, as a first step
following your example we caught a recoverable exception, added a
short delay and tried again, on first look it seems to help.

We will be happy to hear your opinion on these questions:

1) We know ODB objects are thread safe, maybe we did not compile the
Mac libraries properly for multi thread support, to be sure, what are
the compilation directives we need to use for multi threaded support
on ODB libreries for mac and windows ?

2) Should we consider using more then one connection for better multi
threaded performance ?
[maybe consider connection pool or another object practice use?]

3) Other suggestions, advises and best practices on ODB SQLite, thread
safe and concurrency ?

Thank you very much for you kind help,
Erez.