Performance of ADO.NET

Hello All,

We are currently in feasibility study and high level design phase. We need
to choose application design according to performance and maintainance.
Means our main criteria is Performance and easy Maintainance.

We have created one template for just study purpose.

1) Layer That uses Typed DataSet and Stored Procedure
In this template, we used Typed Dataset. But somewhere i read that it is
maintainable but not giving good performance.
Our structure is :
Presentation Layer > BAL > DAL > Type Dataset
Layer > DL

I want information whether this is a good architecture or not.

Can anybody suggest me a good architecture with following criteria.
Use of Stored Procedure everywhere
Performance should be high
DAL and BAL Should be there
Easy to maintain and programmer friendly :)
Give me answers ASAP.

Best Regards, and Thank You in Advance.
Manish

Miha
Fri Dec 05 03:38:33 CST 2003

Hi Manish,

The only performance issue with datasets in general is that they can't be
binary serialized thus you always transfer xml text between layers (if your
layer are separated between different machines).
Otherwise, I see no performance hit using datasets/sp - infact this
combination is used on my big solution :)

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

"Manish Pansiniya" <manish.pansiniya@i-link.co.in> wrote in message
news:%23bxvZ3vuDHA.2712@TK2MSFTNGP11.phx.gbl...
> Hello All,
>
> We are currently in feasibility study and high level design phase. We need
> to choose application design according to performance and maintainance.
> Means our main criteria is Performance and easy Maintainance.
>
> We have created one template for just study purpose.
>
> 1) Layer That uses Typed DataSet and Stored Procedure
> In this template, we used Typed Dataset. But somewhere i read that it
is
> maintainable but not giving good performance.
> Our structure is :
> Presentation Layer > BAL > DAL > Type Dataset
> Layer > DL
>
> I want information whether this is a good architecture or not.
>
> Can anybody suggest me a good architecture with following criteria.
> Use of Stored Procedure everywhere
> Performance should be high
> DAL and BAL Should be there
> Easy to maintain and programmer friendly :)
> Give me answers ASAP.
>
> Best Regards, and Thank You in Advance.
> Manish
>
>

Miha
Fri Dec 05 04:45:21 CST 2003


> The only performance issue with datasets in general is that they can't be
> binary serialized thus you always transfer xml text between layers (if
your
> layer are separated between different machines).

Even for this there is a solution:
http://support.microsoft.com/?id=829740

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com