Re: Limit Rows in DataTable

Brady Kelly <[email protected]> Tue, 29 Apr 2008 15:45:49 +0200
Newsgroups gmane.comp.windows.devel.dotnet.clr
Message-ID <[email protected]>
> Be careful with this.  We recently had a customer do an emailing with
> 22,000
> rows in a datatable in a dataset.  The dataset simply is not designed
> for
> this amount of records and it was SLOW. We broke it up into smaller
> datasets
> of about 500 record each.
>
> Greg

I'm only using high numbers for testing, e.g. I'm testing a whole two year's
invoices, where the normal load is monthly.  I'll normally be looking at a
few hundred for the foreseeable future.  It shows a small lag on loading the
data with of to 20k documents, but processes them lightning fast.

===================================
This list is hosted by DevelopMentorĀ®  http://www.develop.com

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