Re: Limit Rows in DataTable

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

-----Original Message-----
From: Discussion of development on the .NET platform using any managed
language [mailto:[email protected]]On Behalf Of Brady Kelly
Sent: Tuesday, April 29, 2008 5:13 AM
To: [email protected]
Subject: [DOTNET-CLR] Limit Rows in DataTable


I have an application under test, where I iteratively reset an export batch
and then run the export for different configurations.  For major testing, I
wish to test each config over the full monty, 70k documents exported, but
for dev testing I like to keep the rows in each section down to 500.  Last
night in the interests of not breaking code, I was popping 'TOP 500' into
each query, but I'm sure there is a better way.  Any suggestions will be
appreciated.  I'm using a SqlDataAdapter to fill my DataTable objects.


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

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

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

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