I'm playing with millions of records where I fetch 100 records per page with pagination and a search panel to help user if he wants some unique record.
But the questions are:
1: Do I really need to show first 100 records without asking? because user might want the X records which doesn't exist in first 100 records
2: First 100 Records might help if user want to see records on the basis of some criteria
like if I want to see all or 10 students who score >80%.. I click on "student marks>80%" link and I got the list of student, where Max percentage would be on the top. So user will get what he wants.
But in my case I don't have any criteria and I'm not sure what user would be looking for i.e. Does he wants top 10 records? Or details of any specific student.