I have a question regarding the general strategy in opening and closing a database through a transaction program. I have a VB program that is a listening server using winsock. It receives transactions through a listening port. Once it receive a transaction, it then updates a MS SQL database. I think if with every transaction I open and close the database there will be lot of overhead. Is it good practice to keep the database open all the time or is there a smarter strategy. Can any one please provide some suggestions. Thank you in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I have a question regarding the gen
- Thread starter Myrtle
- Start date
Similar threads
- Locked
- Question