Hi Shanker, I would like you to look into couple of things,
1) Why a data manipulation is taking more time when executed using stored procedures. Is there any cursors that is killing performance. is there is any other external factors that is killing the execution plan of a stored procedure. 2) What is your dataset size (typical scenario). This will help you in understanding the problem. 3) What is your usecase and why you need to analyse a huge data set. If you can find an answer to this, i think you will nail the performance problem. 4) What about indexes, (check execution plan and make changes accordingly) The reason why i asked you to look at these things is because, by introducing a new layer (which is not required) we might not be solving the problem but rather we are increasing the complexity. The current model (Presenation + Logic Layer (Generic list) + DAL +Stored procedure) looks to me a typical three tier architecture which is Good in my opinion Thanks, Albert Arul Prakash http://www.bepenfriends.com/ a free online dating web site http://www.facebook.com/yourdatingguru - your dating guru There are only 3 colors, 10 digits, 26 letters, 7 notes and 118 elements; its what we do with them that's important. On Tue, Sep 4, 2012 at 12:17 PM, crazy <[email protected]> wrote: > Hi All, > > Good Day!! > > Please advice me on belwo Case. > > I am designing a B2B application using ASP.net 4.0 for Hotel Room > bookings. The search result related to Hotel rooms require a very huge > manipulations like need to check rate, discount , supplements allocation > etc.. > > In this case , if I use Webservices between DAL and Presentation layer , > does it increase the speed of search process? Or any other tactise exist? > > In the current structrue (Presenation + Logic Layer (Generic list) + DAL > +Stored procedure) I am getting time out error from web application. > > > > -- > "People who never make mistakes, never do anything." > > dEv > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- with luv, Albert Arul Prakash http://www.bepenfriends.com/ a free online dating web site http://www.facebook.com/yourdatingguru - your dating guru There are only 3 colors, 10 digits, 26 letters, 7 notes and 118 elements; its what we do with them that's important. -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
