On Thu, Sep 6, 2012 at 1:12 AM, crazy <crazysan...@gmail.com> wrote: > 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. ---------------------
WCF is not going to improve efficiency and I use them whenever I can. It is only an uber cool adapter adapter for your business logic that encompasses your DAL. That being said current issue is timeouts from data requests? Are there many transactions happening at the same time? IS there table locking in your current SQL? I would guess that the major work is happening all on the data layer and not in the programming layer, .NET. Defining a room request is pretty simple. By property code and date range you just count the existing rows by room type, bed size and smoking. Then compare that count against the layout values for the same property. Sure you can play the soft save when you present the results and that may be where you are getting into trouble. Releasing those "saved" but not requested rooms. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell -- 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
