Disconnected Mode

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 16
Joined: Sat 08 Sep 2012 19:43

Disconnected Mode

Post by markdelphi » Sat 08 Sep 2012 23:22


I have the following question:

Before working with Delphi ADO components. Now I work with SDAC, my work schedule has been: Connect - Run - Disconnect. For this scheme to work, I recommend using the Disconnected Mode with Pooling.?



Re: Disconnected Mode

Post by AndreyZ » Mon 10 Sep 2012 09:51


Yes, to work in the Connect-Run-Disconnect mode, it is correct to use Disconnected Mode. The drawback of using the disconnected mode is that each connection establishment requires some time for authorization. If connection is often closed and opened it can slow down the application work. In this case, we recommend to use pooling to solve this problem. For more information, please read the "Disconnected Mode" and "Connection Pooling" topics in the SDAC documentation.

Post Reply