Re: ADO.NET 2.0 - ResultSet concerns

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Angel Saenz-Badillos[MS] (angelsa_at_online.microsoft.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 11:21:30 -0700

William,
I believe that you have been able to capture the soul of the argument in
these posts, the short and the long of it is that there are some very
specific problems that absolutely require a connected resultset (Some OLTP
apps for example), this feature is also the cornerstone of a much more
requested feature, Paging. However, using this feature when it is not
required is disastrous for scalability and it is almost guaranteed that it
will be miss-used, in fact, I cannot think of a good use of Paging at all.
IMO used in asp.net pages it will slow down servers to a crawl. Another good
point is that, like you mentioned, adding this feature now is going to
confuse the message that we have only now started to get through. The last
point is that for the very rare app that requires server side cursors you
can always use ado or create the cursor yourself with TSQL "declare c CURSOR
DYNAMIC for SELECT ..."

Practically everybody that I have talked to about the v2.0 ado.net features
places this at the top of his concern list and we are looking very carefully
at these features. Thanks for bringing this up, I will forward your comments
appropriately. 

-- 
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
"William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
news:OWKZXW9HEHA.3556@TK2MSFTNGP10.phx.gbl...
> Hi Cor:
>
> I appreciate your opinion and just wanted to follow up.  I think we both
> agree that progress is good and that you need to go forward.  If the
> resultset was included from the beginning, I think it would be a LOT less
> confusing for newbies.  Maybe I'm just being a bit pessimistic in this
> regard, but i foresee a ton of confusion b/c there's still a ton of
> confusion and this will only blur the line.  I suspect that many ADO
> programmers are going to rely on it exclusively and I just foresee some
> confusion.  However, when I start sounding like a Chicken-Little, that's a
> good indicator that I need to quit philosophizing and start reading more
> about a subject.
>
> Thanks again,
>
> Bill
>
> BTW, I responded to the DataReader Limitation post.  didn't mean to step
on
> any toes there ;-)
> "Cor Ligthert" <notfirstname@planet.nl> wrote in message
> news:eBubFf5HEHA.3968@TK2MSFTNGP12.phx.gbl...
> > Hi Bill,
> >
> > History always repeats.
> > When I started data processing, it was in the time of the punching
cards.
> > People where sorting them column by column, when you have to do a lot of
> > columns and a hugs amount of cards that is hard labour.
> >
> > There where also machines with which what you could do intelligent
> sequence
> > checking by making let say program boards (was with wires), took
sometimes
> > time how to do it, but when you did know how,  it was very easy to do
(It
> > was collecting the good sequences into the others while creating let say
> > streams again from the wrongs ones).
> >
> > I think you have seen messages enough from me to understand which way I
> > took. However, there where people in my environment who said I was only
> > lazy.
> >
> > Then we got magnetic tape, that method that I did was of course also one
> of
> > the better methods to sort a tape. However, I did not like the magnetic
> > tape; I did like the disc and especially the disc that could read fast
> > randomly.
> >
> > However, there where people who said using a random disc was not sure
and
> > not as fast as a magnetic tape and they did use the magnetic disc as a
> tape.
> > (Do understand me; there are problems, which still can be done the best
> way
> > doing that.)
> >
> > I can go on of course, but what I want to say is that there are
companies
> > which have there biggest earnings from those people I tell you about.
They
> > still have environments build on the principles of the punch card or
> > environments build on the time the students came in the computing
> business.
> >
> > One of the things I have always like from Microsoft is that they did not
> > listen to those people who are stopping progression. I hope this will be
> the
> > same in future.
> >
> > Just my thoughts about your message,
> >
> > Cor
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: ADO.NET 2.0 - ResultSet concerns
    ... confusion and this will only blur the line. ... > Then we got magnetic tape, that method that I did was of course also one ... > the better methods to sort a tape. ... I did like the disc and especially the disc that could read fast ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET 2.0 - ResultSet concerns
    ... will be the most misused feature ever. ... >> confusion and this will only blur the line. ... >>> the better methods to sort a tape. ... I did like the disc and especially the disc that could read fast ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application to monitor Battery (power or current) usage
    ... Sorry about the confusion - By all means it was not meant to be taken badly ... me another cool feature in a program I use every day. ... thanks for my audible alarms when the rest of the device is ... Terry ...
    (microsoft.public.pocketpc)
  • Re: ADO.NET 2.0 - ResultSet concerns
    ... We received this same feedback across the board. ... > will be the most misused feature ever. ... > ADO was misuse of server-side cursors. ... >>> confusion and this will only blur the line. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why no TV?
    ... Every DVD player I've ever seen has that feature. ... Well my VCR is from 1985 and it has a counter number index (useless unless set to zero at the start of a tape) and a signature index generator at the start of every recording. ... Nels E Satterlund I don't speak for the company, ...
    (rec.arts.sf.fandom)