[dba-SQLServer] For Performance - Leave Connection Open?

Dan Waters dwaters at usinternet.com
Thu Dec 11 11:56:05 CST 2008


In access, I can open and leave open a connection to the BE to noticeably
improve performance.

I'm starting to use SQL Server as a BE (Access mdb as FE), and one of my
clients will be connecting to a BE on a server in the US while they use a FE
in Asia.  So, should I have the same practice in this system?  In this
particular case, there will be a limited number of concurrent users -
probably 5 at the most.

Thanks!
Dan





More information about the dba-SQLServer mailing list