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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Miha,

In my idea you must be a fool to use multithreading for one server.
Your performance will in my idea only be slower by the collesions you can
get more easy.

If it is about more servers than the fact you describes are not true, they
have all their own pool.

Just my thought, never tested.

Cor


"Miha Markic [MVP C#]" <miha at rthand com> schreef in bericht
news:586E8AC2-6EAA-49EC-A3C2-94D62FB4A341@xxxxxxxxxxxxxxxx
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
    ... 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)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • 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)