Binding records taking more time with paging

[Member 3879881]

Hi good morning to all..., I have a lakhs of records in my table..., i am binding this values in my repeater control with paging concept (pageddatasource)..., But i feel its taking more time to bind..., how to face this probs..., give me ur suggestions...,

Thanks & Regards, Member 3879881, please don't forget to vote on the post

[Viral Upadhyay]

If you lakhs of records then i will suggest you to make paging in your database. i.e. fetch as much record as needed like if you display 10 records at time then only fetch 10 records from database.

Viral My Site
Save Our Tigers

[Brij]

As Viral suggested,It will be better if you do the paging at database end itself.

Cheers!! Brij

[Pranay Rana]

check this article in which paging done on database side ASP.NET Extended Grid Control[^]

[Amit M patel]

Yes I am also agree with previous answers, in your case you need to do paging in your database side and each paging time you need to bind grid with new fatched from DB. For paging in Database you can use below logic

select top x * from dbo.EmpDetails where ID not in (select top (x*(p-1))ID from dbo.EmpDetails order by ID)
order by ID

Here X = No records per Page P = Page no.

With Regards, Amit Patel 91-9328488961 India