Thanks all for your valuable comments and suggestions. My scenario is, the inhouse team already developed a booking engine in ASP .NET 2.0 + VB.net ( with out any layer concept) + MSSQL2000. The current structure using TSQL instead of SPs
We are trying to optimize the application. My plan as below : 1. Converting the code from Vb.Net to C# 2. upgarde the project into .NET 4.0 witn Tiering architecture and upgrade DB to MSSQL 2010. 3. Change Application into (Presenation + Logic Layer (Generic list/Webservices) + DAL +Stored procedure) structure. 4. Convert all the TSQLs ito Stored procedures. 5. Optimize the Tables by applying necessry indexes etc.. In Point 3 , I am trying to collect your valuable comments about utilization of Webservices concepts instead of Generic list. Note : I am not sure I have missed anything in my above optimization Plan. On Tue, Sep 4, 2012 at 11:30 AM, Albert Arul Prakash Rajendran < [email protected]> wrote: > 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 < > [email protected]> 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 <[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. >> >> > > > -- > 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 > -- "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
