In order to access a SQLite database, in a multi-threaded environment (in the same process), any advice or heads-up on potential pitfalls?
Do I need separate IDBConnection created for each thread?
Many thanks.
In order to access a SQLite database, in a multi-threaded environment (in the same process), any advice or heads-up on potential pitfalls?
Do I need separate IDBConnection created for each thread?
Many thanks.
As a rule of thumb for database access, yes, use a different IDBConnection for each thread. One IDBConnection relates to one database connection component, be it TFDConnection, TADOConnection, etc., so that's the general approach.
Note that SQLite is not designed for heavy multi-concurrency access and specially writes, so be sure it fits your scenario.
This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.