One more thing, A searching of Hotel room booking does not require a huge analysis upfront.
the use case can be split like below User visits site >> search accomudation >> page displayed with dates they like and with number of occupants, type of room they like >> click search >> Result displayed with query matching dates, type and occupant allowed. Also additionally, another data set can be fired to get amneities that can be added, discounts etc Above two sets are merged in logic layer (middle/business tier) and send to presentation If you process your requirement in chunks i believe it is easy to solve the problem. but still my suggestion to look for couple of places remain same Thanks, Albert Arul Prakash On Tue, Sep 4, 2012 at 12:52 PM, Albert Arul Prakash Rajendran < albertarulprak...@gmail.com> wrote: > 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 <crazysan...@gmail.com> 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 dotnetdevelopment@googlegroups.com >> To unsubscribe from this group, send email to >> dotnetdevelopment+unsubscr...@googlegroups.com >> 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. > > -- 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 dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com 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
