PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET typed dataset and untyped dataset, which one is faster?

Reply

typed dataset and untyped dataset, which one is faster?

 
Thread Tools Rate Thread
Old 10-04-2006, 04:27 AM   #1
=?Utf-8?B?TmFwbw==?=
Guest
 
Posts: n/a
Default typed dataset and untyped dataset, which one is faster?


typed dataset and untyped dataset, which one is faster?
I think the answer is typed, but some one told me is untyped.
Who can tell me the answer and the reason?

thanks

  Reply With Quote
Old 10-04-2006, 06:01 AM   #2
OHM \( One Handed Man \)
Guest
 
Posts: n/a
Default Re: typed dataset and untyped dataset, which one is faster?

There would be some marginal difference, but you are unlikely to notice it.
Using strongly typed DataSets make your coding cleaner, safer and more
readable

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net


"Napo" <Napo@discussions.microsoft.com> wrote in message
news:EFA8B397-0B99-4271-BBB9-1823A656A2CD@microsoft.com...
> typed dataset and untyped dataset, which one is faster?
> I think the answer is typed, but some one told me is untyped.
> Who can tell me the answer and the reason?
>
> thanks
>



  Reply With Quote
Old 10-04-2006, 07:13 AM   #3
Cor Ligthert [MVP]
Guest
 
Posts: n/a
Default Re: typed dataset and untyped dataset, which one is faster?

Napo,

In the use of the Strongly Typed Dataset is a use that is seldom done with
the typed dataset.

That is referencing the columns by the column property instead of string and
index.

That makes de Strongly Typed Dataset by testing mostly slightly faster. As
OHM says is the gain of time so few, that any thinking about this cost more.

Just my idea

Cor

"Napo" <Napo@discussions.microsoft.com> schreef in bericht
news:EFA8B397-0B99-4271-BBB9-1823A656A2CD@microsoft.com...
> typed dataset and untyped dataset, which one is faster?
> I think the answer is typed, but some one told me is untyped.
> Who can tell me the answer and the reason?
>
> thanks
>



  Reply With Quote
Old 10-04-2006, 01:50 PM   #4
W.G. Ryan - MVP
Guest
 
Posts: n/a
Default Re: typed dataset and untyped dataset, which one is faster?

It depends. There's a lot of debate about this. Strongly typed datasets have
a lot of advantages with respect to typing, but as such, have a lot of
try/catch blocks and exception handling that can slow them down. However in
all likelihood, you're going to have to write the same stuff yourself so it
really depends. It's not an apples to apples comparison until you factor in
the exception handling.
"Napo" <Napo@discussions.microsoft.com> wrote in message
news:EFA8B397-0B99-4271-BBB9-1823A656A2CD@microsoft.com...
> typed dataset and untyped dataset, which one is faster?
> I think the answer is typed, but some one told me is untyped.
> Who can tell me the answer and the reason?
>
> thanks
>



  Reply With Quote
Old 10-04-2006, 06:28 PM   #5
OHM \( One Handed Man \)
Guest
 
Posts: n/a
Default Re: typed dataset and untyped dataset, which one is faster?

I use it exclusively.

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net
"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:Ob17hWGXGHA.3760@TK2MSFTNGP02.phx.gbl...
> Napo,
>
> In the use of the Strongly Typed Dataset is a use that is seldom done with
> the typed dataset.
>
> That is referencing the columns by the column property instead of string
> and index.
>
> That makes de Strongly Typed Dataset by testing mostly slightly faster. As
> OHM says is the gain of time so few, that any thinking about this cost
> more.
>
> Just my idea
>
> Cor
>
> "Napo" <Napo@discussions.microsoft.com> schreef in bericht
> news:EFA8B397-0B99-4271-BBB9-1823A656A2CD@microsoft.com...
>> typed dataset and untyped dataset, which one is faster?
>> I think the answer is typed, but some one told me is untyped.
>> Who can tell me the answer and the reason?
>>
>> thanks
>>

>
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off