Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Typed Datasets and performance

Thread Tools

Typed Datasets and performance

Posts: n/a
Are there any performance issues with typed datasets in a fairly high
performance system?

Reply With Quote
Posts: n/a

Typed dataset allow you to maintain the code more easily (autocompletion,
column names...). It also check the constraints when you insert rows or data
in you dataset (so you don't have a call to the database to know it
constraints are OK). It can be very usefull for master/details tables.

The problem of performence depends on the amount of data you're using and
what you're doing with the Data.
I have an old project where I have to check "manually" constraints on 12 000
rows in a dataset. There is approximately 15 columns. The "foreach"
statement takes about 20 second to end on a P4 3Ghz 3Go RAM. The tests loops
from one table and do some job comparing values on a second table.

I have an other project with 50 000 rows using typed dataset. To each row
correspond a details row. The fill method is quite long (about 1,5 or 2
seconds). But after everything is checked each time i'm changing values. So
I think this is a good way to work.

It really depends on what you're trying to do.

Not sure it helps but you should describe more your project !!


"Chris" <(E-Mail Removed)> wrote in message
news:OiyQE%(E-Mail Removed)...
> Are there any performance issues with typed datasets in a fairly high
> performance system?

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Typed Datasets - Performance over WebServices (1 Dst or Various Sm =?Utf-8?B?SXbDoW4gUMOpcmV6?= ASP .Net 3 08-14-2007 10:46 PM
App Architecture: Typed Datasets, EntLib, Performance Karch ASP .Net 5 09-14-2006 01:48 PM
Problem with Typed Datasets and Web Services Sparky ASP .Net 0 11-15-2004 09:02 AM
Strongly typed datasets and XML Big D ASP .Net 1 02-17-2004 11:32 PM
Traditional Collections and Objects or Typed Datasets ? Rob Thomas ASP .Net 3 08-26-2003 09:06 PM