data access from sql 2005

i am using asp.net with sql 2005.

here i am having lakhs of records .

when we retrive the records it became very slow. it takes long time to retrive the datas from sql.

i used index,stored procedure,but no use. Any one know how to access the datas in fast manner.

First question would be have you tried executing the stored procedure directly from SQL Query Analyser / Management Studio? This is to determine whether it is a database issue or application issue?

If this is a database issue then you will have to look into appropriate column indexing, minimising table joins, optimise the query execution plan

If it points to an application issue, then make sure you are disposing connection objects, use appropriate command objects like readers and adapters, only fetch data you need, consider caching if the data is static in nature