Re: ANN: Query A Dataset Beta Download

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
    ... > 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
    ... > inefficient. ... >>> a full SQL query engine against a ADO.NET DataSet, ... >> 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: 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)