TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Akshaya arumugam
NA
183
23.4k
implementing Pagination in sql server
Nov 22 2018 11:22 PM
I have 20 lakhs of records.I want to implement pagination in fetch of these records with improved performance.On click of search it fetches the first 10,000 records on click of next it fetches the next ten thousand records like wise until the reaches the count same wise previous should work.But the problem is performance is very low when it fetches.I tried offset/fetch,creating non-clustered index to all select fields,joins and where .i need help to improve performance of it..
Reply
Answers (
3
)
Need to performance test a database design
BCP utility on SQL managed instance.