How can handle Large Database

Question

hi Frnds!!!
 

i developed application in C# ,and Create Database in SQL server - 2008.
 
problem in load windows form.(Form contain DataGrid View for display Record)
 
application is work absolutely fine upto 15000-20000 record, but if data like 120000 - 150000 then Form Load Speed is too slow.
 
In short performance issues while Form Load, How can Handle this issues??? any solution like paging, virtual Mode etc!!!!.

Answer 1

Hello King,

You can create an indexed views to help you with performance. For details please refer:

Creating Indexed Views

Improving Performance with SQL Server 2008 Indexed Views

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.