Hi,

My application requires to access a lot of data from database. This makes it little bit slow.

Which design pattern will be suitable in this context? 

There are many other factors involved in the decision of an object design pattern, you should start by looking here: Gang Of Four Patterns

If your application is running slowly I would look at the various types of caching available and make decisions on where this could be used in your app - it could be handled inside the Business Layer, or you could have your own layer ontop of the business layer. Alternatively it could be handled right away by the DAL layer.
 

<ppayal> wrote in message news:2253728@forums.asp.net...

Hi,

My application requires to access a lot of data from database. This makes it little bit slow.

Which design pattern will be suitable in this context? 

 

---

http://forums.asp.net/p/1238180/2253728.aspx#2253728

If your application has been developed and is running slow, then design patterns wouldn't be my first point of call. I would look at the SQL queries as this has been the bottle neck for me a lot of times. 

Also try to make the application grab chunks of data and implement caching as one of the other replies has already stated.

As for design patterns, this is a very fluffy question that doesn't really have a correct answer.  If I were you I would look at the Enterprise Library and either the Smart Client Software Factory or the web equivanent depending on what platform you are targeting.

Some patterns you may want to reseach are:

Repository Pattern
Data Transfer Objects
Data Mapper Pattern

You may also want to look at other example 3 tier applications and get a feel of what patterns they are using and whether these would work for you.  I would recommend the Timok exaple (google it).

I hope this helps...

B

To improve the performace of your application you may find these articles helpful, they have a lot of information on handling/displaying large amounts of data

• ASP.NET 10 Tips for Writing High-Performance Web Applications
  http://msdn.microsoft.com/msdnmag/issues/05/01/ASPNETPerformance/
  
• Speed Up Your Site! 8 ASP.NET Performance Tips
  http://www.sitepoint.com/article/aspnet-performance-tips
  
• Paging of Large Resultsets in ASP.NET
  http://www.codeproject.com/KB/aspnet/PagingLarge.aspx

I hope you find them helpful.