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

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 15:29:07 -0500

Again, this kind of performance gain is unlikely to be a factor when you're
dealing with one insert at a time. I understand, and stated earlier, that
is likely to be worth pursuing when you're at high volume. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in 
message news:%23JtPPJREEHA.3980@TK2MSFTNGP09.phx.gbl...
>> 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.

Relevant Pages

  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... dealing with one insert at a time. ... > I recall an article in SQLMag a few years back by Bill Vaughn where he ... > Bill's assumption here as well was that the major part was in the ADO ...
    (microsoft.public.inetserver.asp.general)
  • Re: I need a good book or two on ADO
    ... Bill Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... "Arnie Mauer" wrote in message ... And, I mean good old ADO, not ADO.NET. ...
    (microsoft.public.data.ado)
  • Re: ADO.NET vs ADO
    ... Scott is as well a long time contributer too the ADO.Net newsgroup, like Bill Vaughn, in past David Sceppa and I. ... I would recomend you the following writers Bill Vaughn, Francesco Balena, David Sceppa. ... benefits of ADO .NET vs. the pitfalls of ADO. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: 0x800a0cb3 when Update record
    ... Where's Bill Vaughn when you need ... ADO takes the initial query and builds its own Update SQL query ...
    (microsoft.public.data.ado)
  • Re: Fujitsu ADO Data access guidance needed
    ... tutorial or reference material regarding the use of ADO to access Microsoft SQL server, under Fujitsu PowerCobol v6.1 ... Some years ago I recall that I used embedded and SQL and ODBC with Fuji version 5 but that's all rather fuzzy to me now. ... I think I saw a post here stating that ADO is better. ...
    (comp.lang.cobol)