BorlandTalk.com

Guest

We have an app that uses TAdoDataset and client-side cursors to access
SQL Server 2K for all queries except one. I noticed that whenever the
server-side query executes, every query that executes after that
causes a database connect before the query and a disconnect after the
query, even for the client-side cursors. This can cause a lot of
overhead.

We changed the server-side cursor to a client-side cursor and the
problem went away. But I'd still like to know what causes this
behavior, and if theres a way to keep the database connection
persistent?

Thanks,

Tom