Hi all, I am querying a large table with millions of record based on some condition. Say this results in a 70 thousand records. Then again this 70 thousand records are filtered based on 2 three levels of conditions and finally I get a 30 thousand records. I want to achieve pagination and I should not hit the database again as well,Currently I do this way. I read all the 30 thousand records and store all the records in a file. I just use file pointers and manipulate things and achieve pagination to show 1000 records per page. Whenever the user request for the next page, I go to the file read it and display the next page and so on But I feel this is not the efficent way to do this as I get lot of errors while I do paginations because of the file pointers. Can somebody enlight me by suggesting an efficent method to do this.