Re: DataTable efficiency

> One of the problems I have with ADO.net, is Microsoft forgot to
mention
> exactly how
> efficient their code is.  This doesn't matter for a lot of things, but
> with database stuff
> and lots of data, people would like to know.  If I load data into a

I think once you actually get to grips with what you are asking, you may
realise why it's not documented.
First you need to define "efficient": are you wanting memory efficiency;
time efficiency, etc?

What happens when in some cases it's memory efficient, and in other
cases it's time efficient depending on the inputs/external conditions
(table size, index size/layout, etc)

Any measurements that *were* documented would be useless in any
situation other than that used during the measurements.
In fact the presence of those measurements would probably guide people
into using one method over another in ALL cases - even those where other
techniques would be a better choice.

By far the easiest and safest approach if you need to squeeze out a
particular level of performance from your app is to measure your code in
typical scenarios in which it's going to be used.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This list is hosted by DevelopMentor=AE  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com