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