Posted by Greg D. Moore \(Strider\) on 12/07/06 04:45

"davep" <dvs_bis@sbcglobal.net> wrote in message
news:GQHdh.5113$hI.3104@newssvr11.news.prodigy.net...
>I have tcpip enabled....not a problem
> i was just wondering if is should also
> Enable Named pipes
>
> with tcpip over named pipes
>
> Basicly Because i do not know....
> What is the best Performance and or Practices

Best practice, optimize your queries. Return only the data that is needed.
Avoid stuff like select * from FOO.

Network protocol will be one of the smaller performance tweaks you can make.


>
> tia
> Dave
>
> "Jonathan Roberts" <gremln007@diynics.com> wrote in message
> news:kLGdh.8336$8H6.2308@newsfe22.lga...
>> davep wrote:
>>> new bie....i have a server
>>> for best preformance should i
>>> set protocols to tcpip only or
>>> tcpip, named pipes and tcpip over named pipes
>>>
>>> thanks
>>> dave
>>>
>>>
>>
>> How do you connect from your application(s)?
>
>

[Back to original message]