Re: Update dataset/datatable disconnected?

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

From: Cor Ligthert (notmyfirstname_at_planet.nl)
Date: 02/13/05


Date: Sun, 13 Feb 2005 18:56:43 +0100

Hi Sahil,

>
> It really depends on how many rows. If you go row by row, as in pure SQL,
> then you are hitting the database multiple times, and the logs of the
> database are getting bigger by an order of a lot. So the small perf hit
> you pay to hold the larger objects, is worth it in my opinion.
>
> The downside obviously is that your solution now becomes very very db
> specific, which in most enterprise wide projects is not a big deal since
> they are married to a major db anyway (oracle/sql server/db2).
>

It is not that late in the US.

See the topic, we are talking about a disconnected datatable, what do you
mean

:-)

Cor