I'm working on a web application where I've to interact with database again and again. And database is also very bulky some tables having more than 50000 records. And records from these tables are being used to view in other pages very frequently. And in fetchig records it's taking normal time but as per client requirement it should be faster and faster as fast as possible. So i'm looking for an any way through which fetching records will be faster and fastest as possible. Someone has suggested me to go with WINDOW SERVICES to improve the speed in my web application.

Hi there,

I don't see how Windows Services can speed up the retrieval of data in a web application. It only adds another layer of overhead.

What you could so is:

1. Optimize the database. Make sure you have optimized indexes on your tables, optimize queries (only select columns and records you need), optimize statistics, use database paging and a lot more. This is a good start: http://www.google.com/#hl=en&source=...se+performance

2. Cache data that doesn't frequently change. Again, Google is a good starting point: http://www.google.com/#hl=en&q=cache+data+.NET

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!