>>Hi everybody,
>>
>>I have a theoretical question. If we're working with SQL Server, what is the commonly-used practice: open connection at the beginning of the application and close it at the end or open and close only when sending requests to the server?
>>
>>I have this question for VFP-SQL Server applications and for .NET applications.
>>
>>(I'm going to cross-post in .NET forum).
>>
>>Thanks a lot in advance.
>
>No need to cross post to .Net. Open and close as needed. Keeping a connection open is more costly than getting it again from the pool. 'Disconnected' is .Net's favorite:)
>Cetin
Thanks, Cetin. That's what we implemented, but just wanted a confirmation if this is right.
If it's not broken, fix it until it is.
My Blog