SQL Server 2008

[Member 4650287]

Dear All, We have a table with millions of records,i created a Windows application to retrieve data from mentioned table,it taking too much time to get result,I loaded data in the form load event,its stucking for few minutes to display as data is too much. anyone can help me out to find any way to retrieve data w/o stuck the application? thanks

[Blue_Boy]

Do you really need to load million of rows from table on load of form?

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com

[Member 4650287]

No ... I realized

[Corporal Agarn]

Besides adding criteria (WHERE) to the data request look into indexes.

[Blue_Boy]

Member 4650287 wrote:

I realized

You realized what?

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com

[thatraja]

Use paging and filtering in result-set. Look at this article. SQL Server Paging Results[^]

thatraja

---

**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**

[jschell]

You can't be creating a report with millions of lines. So you are actually creating something else. Instead of getting those millions of lines and then processing them you should write a stored procedure that gets only the data you need.

[Member 4650287]

thanks for replies