I think i had similar situation before...but not sure if it is exactly the same..... that time i used datareader alot but forgot to close it at the end of method.
Check your datareader...make sure it is closed properly after being used. On Thu, Sep 6, 2012 at 8:56 PM, Stephen Russell <[email protected]>wrote: > On Thu, Sep 6, 2012 at 1:12 AM, crazy <[email protected]> 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 [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 > -- <http://www.satuindonesia.com.au> -- 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
