Use store procedures instead of these. Try to fetch data at a time from server and use on page. dispose objects after use.
This will help Jack On Wed, Nov 19, 2008 at 9:24 AM, Troy International <[EMAIL PROTECTED]>wrote: > Can you wat are the steps to improve the site performance > > yes i have used the select * from query... > > > On 11/19/08, Stephen Russell <[EMAIL PROTECTED]> wrote: >> >> Not sure that Linq is a speed benefit with respect to SQL data. Been >> there and done that. >> >> >> >> >> >> ………………………………………………………………… >> >> Stephen Russell – >> >> Senior Visual Studio Developer, DBA >> >> >> >> Memphis, TN >> >> 901.246-0159 >> >> >> >> >> >> *From:* [email protected] [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Brandon Betances >> *Sent:* Tuesday, November 18, 2008 3:39 PM >> *To:* [email protected] >> *Subject:* [DotNetDevelopment] Re: How to improve site speed ... >> >> >> >> Silly people still using ADO.NET <http://ado.net/> and querying the DB >> everytime they want to manipulate the data. Learn about the Cache, >> Application class, LINQ, and XML for simpler data storage. >> >> Also if you not using a webserver or local IIS, the VS Development Server >> is very slow. >> >> On Tue, Nov 18, 2008 at 8:23 AM, Stephen Russell <[EMAIL PROTECTED]> >> wrote: >> >> >> Less is More is a design philosophy that few people understand. >> >> Are you doing any Select * from ..... for your data? >> >> >> >> ......................... >> Stephen Russell - >> Senior Visual Studio Developer, DBA >> >> Memphis, TN >> 901.246-0159 >> >> >> >> >> -----Original Message----- >> From: [email protected] >> [mailto:[EMAIL PROTECTED] On Behalf Of Venkatu >> Sent: Monday, November 17, 2008 11:11 PM >> To: DotNetDevelopment, VB.NET <http://vb.net/>, C# .NET, >> ADO.NET<http://ado.net/>, >> ASP.NET <http://asp.net/>, XML, XML Web >> Services,.NET Remoting >> Subject: [DotNetDevelopment] How to improve site speed ... >> >> >> hi >> >> Good morning to all >> >> I have created a web project it working fine , but its slow,.... >> >> so how shall i improve the speed of the site.. performance speed >> >> Let anyone suggest a solution.../ >> >> Thanks >> >> No virus found in this incoming message. >> Checked by AVG - http://www.avg.com >> Version: 8.0.175 / Virus Database: 270.9.4/1790 - Release Date: 11/17/2008 >> 8:48 AM >> >> >> >> No virus found in this incoming message. >> Checked by AVG - http://www.avg.com >> Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 11/18/2008 >> 11:23 AM >> >> >
