473,325 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Typed Datasets and performance

Are there any performance issues with typed datasets in a fairly high
performance system?
Apr 1 '07 #1
1 1167
Hello,

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 !!

Ornette


"Chris" <no****@nospam.comwrote in message
news:Oi****************@TK2MSFTNGP06.phx.gbl...
Are there any performance issues with typed datasets in a fairly high
performance system?

Apr 1 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: BeanTownBizTalkGuru | last post by:
Good Morning; I am collecting feedback on typed datasets vs class representation implementation using automated code generated by XSD.exe. I can see the benefits for a typed dataset for a rich...
0
by: Bj?rn Mor?n | last post by:
I am consuming a web service that returns arrays of classes which can contain other classes (a hierarchy of data). Is there a simple way to move the data into a typed DataSet without writing too...
3
by: Rob Thomas | last post by:
Hi, I've been tasked to come up with a new architecture for a large application at one of my customer's sites. In the past, I have developed multi-tier applications whereby the business...
0
by: Luqman | last post by:
While designing an application, should we use Typed Datasets or Object Datasource ? Do Typed Datasets take more resources on Web Server or any better solution to connect the sql Server Database...
4
by: Ronald S. Cook | last post by:
I've always used untyped datasets. In a Microsoft course, it walks through creating typed datasets and harps on the benefits. It has you drag all these things around ..wizard, wizard, wizard......
21
by: Peter Bradley | last post by:
Hi all, This post is sort of tangentially related to my earlier posts on configuration files for DLLs. Does anyone know how to create typed DataSets using VS2005's new DataSet designer, but...
3
by: =?Utf-8?B?SXbDoW4gUMOpcmV6?= | last post by:
Hi there, I have a question that has been raised on how an application should handle the data that is travelling through a three-layered application. Our data is going to be handled by Dataset...
4
by: Rachana | last post by:
Hi, I have understood Data Sets but what is meant by typed/untyped/ strongly typed datasets. Can any one explain me or suggest any site/ article, to get these concepts (and their ...
12
by: BillE | last post by:
I'm trying to decide if it is better to use typed datasets or business objects, so I would appreciate any thoughts from someone with more experience. When I use a business object to populate a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.