SqlDataAdapter and Update grams

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if theres ever been any development effort of writing an
extended version of SqlDataAdapter that uses updategrams to update a dataset.
I'm curious if the reduced network round trips would be a sizable
performance gain. An entire dataset worth of updates/inserts/deletes could be
sent in one request, instead of many.

If so, please point me at a link, if not please provide feedback on why you
think this would or would not be a good idea to do. Thank you.
 
No, I think it's a good idea--so does MS. ADO 2.0 permits you to set a
"batch size" that determines how many operations are sent in a single round
trip. You can try this out with the new VS 2005 beta 1.
I'll be showing how to do this in my Workshop at VSLive in August and in my
SQL Immersion workshop in October.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Phuey then :)

Yea, I actually found out later after some more reading that SQLXML just
converts the updategram to multiple statements anyway, since its just layered
on top of SQL. So the benefits are simply in less round trips through the
network and through ado.net. which is in itself nice, dont get me wrong, hehe

I keep reading conflicting reports on performance gains, some say its
comparable to best practices using vb6/ado, some were based on .net/ado.net,
some state 4-10x gains in insert/delete performance. even within MS articles
its hard to find a single source of definitive information.

any real life experience and aftermath of design decisions to use sqlxml
would be nice.
 
It's not fair to judge Whidbey/Yukon at this point--it's distributed in
"debug" builds and it's not very fast to do the most ordinary things.
Yes, each round trip takes time. Less round trips improves performance, but
you'll get even more by performing more work on the server--which requires
just one or two.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
oh I understand, not negative in any way, but both your posts referred to a
yet unreleased product, in both situations I was referring to whats available
for production use today, and what could be observed today ;)

irregardless, thank you for your speedy posts though.
 
Back
Top