CODEWITHSUNDEEP
asp.netsql-servergridviewssrs-2008
JGC
JGC

Reputation: 12997

Performance issue in Getting report using gridview from tables and view in SQL server

I have a database which has some table and every one of them has at least 100000 records. I need to show reports of these data to admin of asp site so I have used views to join these table to get my required info to show. but the problem is when I run the page although it should show just 10 records for first page and other records can be lazy, it become time out because it takes so long time to make view and show in gridview. Is there any way to handle this problem?
for example If I can make these joins for view when sql server is idle it will improve performance issue. But I don't know is it possible or not

Upvotes: 0

Views: 225

Answers (2)

Karan Shah
Karan Shah

Reputation: 752

hi how about using paging and loading data on request in gridview i mean here is an example hope this might help you:

Loading data on request and paging

Upvotes: 1

JayOnDotNet
JayOnDotNet

Reputation: 398

I recommend you to use custom paging in you sql query

Upvotes: 0

Related Questions