ASP.NET - optimize the grid view haing large amount of data

hi All,

i have a gridview control in my asp.net page
Actually it was not like a normal gridview cntrl
it was a nested gridview to show up the master details from the database

i dnt want to use pagging and sorting in the gridview becas the need is to display everthing in a single page
Everything was working what i expected but i want to improve the performance of that particular page means want to reduce the response time from server
i using only that grid view in that page ..no other conrol is executing in that particular page

how can i improve the performance ...?  any advice ...?



thanks in advance
Muthu

Hello,

You need to use AJAX

To increase the speed of SQL SELECT query, you can analyze the following issues: 

·

http://componentace.com/help/absdb_manual/tabsquery_requestlive.htm property value

·

Available indexes for conditions from WHERE clause

·

Rewriting a query with OR conditions as a UNION

·

Available indexes for JOIN conditions

·

Available indexes for ORDER BY clause

·

Available indexes for GROUP BY clause

·

Select from in-memory tables

·

SELECT INTO vs INSERT SELECT

http://componentace.com/help/absdb_manual/increasesqlperformance.htm