Posted by Bob Barrows [MVP] on 08/29/07 14:49

raymond_b_jimenez@yahoo.com wrote:
> I've noticed in my .NET application (with ADO)

Classic ADO? I.E., with ADODB?
or ADO.Net?

I was going to paste in my standard "dotnet" reply, but I just noticed
that you crossposted to some dotnet groups. You need to be aware that
classic (non-dotnet) ado and ado.net are two very different things. This
question is off-topic in one of the ado groups you included in your
crosspost. It is also off-topic in the sqlserver.server group. Since I
am posting via msnews, this reply will not likely make it to the comp
group. When you follow up to this, please remove the off-topic groups
from your post.


> that whenever a query
> is done to SQL Server, a query executing
> SET NO_BROWSETABLE ON
> is done before.
> This has an huge impact on performance, as the round-trip to the
> server takes the same time as the correct query. I believe that if
> "SET NO_BROWSETABLE ON" wasn't executed, performance would almost
> double and network traffic would be reduced.
> I've tried to find a reasonable answer on the net for this, but
> haven't managed. Has someone noticed this and knows how to correct it?

I've never noticed this, but i am sure the technique used to execute
your queries might have something to do with it. Be sure to post a small
repro script to whichever group you follow up with

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Back to original message]