Re: ANN: Query A Dataset Beta Download

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
>
>


.

Relevant Pages

  • Re: ANN: Query A Dataset Beta Download
    ... > For anyone who might have visited the web site before or anyone needing ... > a full SQL query engine against a ADO.NET DataSet, ... ADO.NET datasets are *horribly* inefficient. ... embedded Firebird which require no installation, just a DLL and an ADO.NET ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ANN: Query A Dataset Beta Download
    ... > Microsoft MVP ... >> inefficient. ... >>> temporary tables in a local cache DB and fetch it from there unless you ... MSDE can be an installation issue, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ANN: Query A Dataset Beta Download
    ... > " QueryADataSet can be used in back-end web servers for querying cached ... > ADO.NET datasets are *horribly* inefficient. ... > temporary tables in a local cache DB and fetch it from there unless you ... > embedded Firebird which require no installation, just a DLL and an ADO.NET ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: FTP software
    ... Then I installed it for Windows ... |the installation files of software I load on my PC. ... Anyone who thinks government owns a monopoly on inefficient, ... bureaucracy has obviously never worked for a large corporation. ...
    (comp.infosystems.www.authoring.html)