Re: Return Key (identity) on INSERT operation (SQL/ASP)

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 21:06:14 +0100

> I think I've seen similar writings elsewhere, perhaps in Bill Vaughn's
> ADO/ADO.NET book.

I recall an article in SQLMag a few years back by Bill Vaughn where he
measured I believe a few thousand times improvements using out params
compared to a result set. This was, as I recall it, ADO and I believe that
Bill's assumption here as well was that the major part was in the ADO
handling. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:uRwU74QEEHA.3040@TK2MSFTNGP12.phx.gbl...
> Actually, when you have a high number of inserts, it's not so negligible.
> Craig Utley did a cool article on output vars vs. rowsets in SQL Server
> Professional:
>
> http://www.pinpub.com/html/main.isx?sub=64&story=729
>
>
> He used ASP pages as a test harness.  Craig seems to think that the
payback
> is in ADO - less overhead in handling the rowset than the output var.
>
> I think I've seen similar writings elsewhere, perhaps in Bill Vaughn's
> ADO/ADO.NET book.
>
>
> -- 
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
>
> "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:#nc$owQEEHA.2968@TK2MSFTNGP12.phx.gbl...
> >> My $0.02.  In addition to Tibor and Aaron's comments, I'd avoid using a
> >> row set and go with using an output parameter with your proc.  It's
more
> >> efficient.
>
> Yes, but the difference is negligible -- unless you're up into the
thousands
> of concurrent users.  The verbose and troublesome command object syntax
that
> would be required in ASP to handle the alternative approach is hardly
worth
> the trouble, if the only reason is to use the "more efficient" output
> variable.  That's my $0.02, and though I'm in the states, it's on par with
> your CDN$0.02.  :-)
>
> -- 
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>

Relevant Pages

  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... > I think I've seen similar writings elsewhere, perhaps in Bill Vaughn's ... I recall an article in SQLMag a few years back by Bill Vaughn where he ... > Craig Utley did a cool article on output vars vs. rowsets in SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: Surface area configuration connection issue
    ... I am sorry Bill, I did not understand. ... "William Vaughn" wrote: ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Merge Replication Problems
    ... Sorry Bill, I'm not familiar with any Session object used when performing ... Hitchhiker's Guide to Visual Studio and SQL Server ... I would have expected Merge Replication to ...
    (microsoft.public.sqlserver.ce)
  • Re: Merge Replication Problems
    ... Thanks for the response Bill, we have several installations which do not ... Hitchhiker's Guide to Visual Studio and SQL Server ... are begin added in the device database, ... Windows Mobile 5 device ...
    (microsoft.public.sqlserver.ce)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... Craig Utley did a cool article on output vars vs. rowsets in SQL Server ...
    (microsoft.public.inetserver.asp.general)