I am writing a VB.NET program that runs an X-ray analyzer from a PC embedded
in the analyzer. The program records results of the analysis every 2-3
minutes into a SQL Server database. In some cases, the SQL Server will be
MSDE on the embedded PC, in other cases it may be another SQL Server on the
LAN. The analyzers run 24x7. My question is, given this scenario, what
would you consider "best practice" for handling the SQLConnection object?
Should it be opened continuously? or opened & closed for each write to the
Thanks for any comments/suggestions....