Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Advice for 1-Tier architecture

0 views
Skip to first unread message

Yev

unread,
Nov 23, 2009, 9:28:01 AM11/23/09
to
Can I get an advantage of the fact that my application is running on the same
computer as SQL Server 2005 express? Is there faster way to connect to the
data base than TCP/IP sockets?
I need to operate as fast as possible. Any advice on configuration?

Andrew J. Kelly

unread,
Nov 23, 2009, 10:50:47 AM11/23/09
to
If it is the same server you are most likely going to connect thru shared
memory. But the protocol is most likely going to be your bottle neck when it
comes to performance. The fact you are using express and it will be on the
same computer is cause enough for concern if you are that worried about the
connections.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Yev" <Y...@discussions.microsoft.com> wrote in message
news:F2ADFD09-0F17-4BFE...@microsoft.com...

TheSQLGuru

unread,
Nov 23, 2009, 11:19:11 PM11/23/09
to
Hmm. If you need things to operate as fast as possible and you are asking
questions like this I HIGHLY recommend you get a good performance consultant
in to help with review, architecture, capacity planning, configuration,
tuning, etc.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Yev" <Y...@discussions.microsoft.com> wrote in message
news:F2ADFD09-0F17-4BFE...@microsoft.com...

sloan

unread,
Nov 30, 2009, 11:39:16 AM11/30/09
to

"back in the day",

http://support.microsoft.com/kb/238949

The following connection string:

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=<User ID>;Initial
Catalog=pubs;Data Source=<YourDataSourceName>;Network Library=dbnmpntw"

tries to connect to SQL Server through the SQLOLEDB provider using the Named
Pipes network library.


Now, that was "back in the day", and I haven't tried anything ado.net 'ish
with this.

But using named pipes would be the faster "me-computer TO me-computer".

Maybe that will provide the hint you're looking for.

..........

I know MS still thinks about it, because WCF has syntax for using named
pipes.

Check this post:
http://seherstrange.com/
He is using http://seherstrange.com/ with an express sql server database.

"Yev" <Y...@discussions.microsoft.com> wrote in message
news:F2ADFD09-0F17-4BFE...@microsoft.com...

sloan

unread,
Nov 30, 2009, 11:41:08 AM11/30/09
to
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

There is some new-school references.

"sloan" <sl...@ipass.net> wrote in message
news:uSdvpud...@TK2MSFTNGP06.phx.gbl...

0 new messages