Page 1 of 1

Thread safe

Posted: Tue 04 Apr 2006 21:09
by QwiqBart
Hi,
We are planning to create a second thread in our application because we excute sql's that result in 100's of thousands of records inserted in the database. According to the Delphi helpfile, the dbExpress data access components are thread safe, provided the vendor client library is thread safe. Is this the case for dbexpsda.dll ?
Thanks !

Posted: Wed 05 Apr 2006 08:34
by Jackson
dbExpress driver for SQL Server is thread-safe and you can use it in multithread applications.
However, there is a restriction. The same connection cannot be used in several threads. So if you have multithreaded application it should have its own connection set for each thread that uses DbxSda.