Re: reuse connection object with diff username passwor ...

Hi Bill,

"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message news:e9lzFmLEHHA.4112@xxxxxxxxxxxxxxxxxxxxxxx
I disagree. In a Windows Forms application the extra overhead of opening an closing connections hurts performance more than it limits scalability. Reopening a pooled connection is far from free.

It certainly isn't free but it is not much either. Do you have any numbers handy?

The vast majority (over 90%)
of these applications are designed to support 5-500 users. SQL Server can easily handle that number of connections X2.

And certainly only one database is active on sql server? IOW what if there are three databases each with 500 users?
It doesn't matter if you are pooling or not in singlethreaded apps (actually it might if you set min pool size = 0), but it makes all the difference is multithreaded ones.

Open the connection, leave it
open and serialize the operations. I've also seen successful apps where the layered forms open their own connection.

What about multithreading? Are you going to have a connection per thread?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

.

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)