Hi,
if you are using gridview to show your data proceed following steps,
1) add paging to your gridview.
2) depend upon paging fetch data using
Row_Number
3) use pagelevel caching.
this primary steps will increase speed to load of your page.
or you can also follow links given in vani kulkarni.
thanks
-Amit