Re: ANN: Query A Dataset Beta Download
- From: "Sahil Malik [MVP]" <contactmethrumyblog@xxxxxxxxxx>
- Date: Mon, 6 Jun 2005 21:52:05 -0400
I agree Bill !!! Datasets have a lot of undeserved bad impression about
them - which in my mind is expressed by the phrase "Little knowledge is a
dangerous thing".
- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/
"William (Bill) Vaughn" <billvaNoSpam@xxxxxxxxx> wrote in message
news:%23bcZ39taFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> This will be interesting. According to what I've been seeing, DataSets are
> a lot more efficient--especially when used correctly. Even DataSet filled
> with far too many rows (>10,000) perform far better (esp. in 2.0) than
> earlier versions.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> www.sqlreportingservices.net
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
>
> "Sahil Malik [MVP]" <contactmethrumyblog@xxxxxxxxxx> wrote in message
> news:%23Kg$A0raFHA.2768@xxxxxxxxxxxxxxxxxxxxxxx
>> Chad,
>>
>> If you don't mind, I'd like to dicuss your perception of Datasets being
>> inefficient. Could you point out specific instances?
>>
>> - Sahil Malik [MVP]
>> Check out my ADO.NET 2.0 book - http://tinyurl.com/9bync
>>
>>
>> "Chad Z. Hower aka Kudzu" <cpub@xxxxxxxxx> wrote in message
>> news:Xns966C6434E4FB0cpub@xxxxxxxxxxxx
>>> "Adrian Moore" <queryadataset@xxxxxxxxxxx> wrote in
>>> news:OWH9PEXaFHA.2520@xxxxxxxxxxxxxxxxxxxx:
>>> > For anyone who might have visited the web site before or anyone
>>> > needing
>>> > a full SQL query engine against a ADO.NET DataSet, you might be
>>>
>>> It does look interesting - but..
>>> " QueryADataSet can be used in back-end web servers for querying cached
>>> DataSets for presentation."
>>>
>>> ADO.NET datasets are *horribly* inefficient. I use them only for
>>> transport
>>> and databindings as with small datasets the inefficiency is neglible.
>>> But
>> to
>>> use them as you suggest, it would be MUCH more efficient to create
>>> storage
>> or
>>> temporary tables in a local cache DB and fetch it from there unless you
>> have
>>> minimal data, in which case you would not need to query it...
>>>
>>> I think your idea is an interesting one, but because of the
>>> inefficiencies
>> of
>>> the ADO.NET dataset its not useful in the server. It could be useful in
>>> clients, but then again anything of queriable size it would be better to
>> use
>>> a local DB. MSDE can be an installation issue, but there are DBs liek
>>> embedded Firebird which require no installation, just a DLL and an
>>> ADO.NET
>>> assembly for the .NET provider.
>>>
>>>
>>> --
>>> Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
>>> "Programming is an art form that fights back"
>>>
>>> Blog: http://blogs.atozed.com/kudzu
>>
>>
>
>
.
- Follow-Ups:
- Re: ANN: Query A Dataset Beta Download
- From: Frans Bouma [C# MVP]
- Re: ANN: Query A Dataset Beta Download
- References:
- ANN: Query A Dataset Beta Download
- From: Adrian Moore
- Re: ANN: Query A Dataset Beta Download
- From: Chad Z. Hower aka Kudzu
- Re: ANN: Query A Dataset Beta Download
- From: Sahil Malik [MVP]
- Re: ANN: Query A Dataset Beta Download
- From: William \(Bill\) Vaughn
- ANN: Query A Dataset Beta Download
- Prev by Date: Re: connection options to yukon
- Next by Date: Re: ID Row Just Added
- Previous by thread: Re: ANN: Query A Dataset Beta Download
- Next by thread: Re: ANN: Query A Dataset Beta Download
- Index(es):
Relevant Pages
|
