ketankshah
IS-IT--Management
I am using asp page to show search results from my item table which has around 100,000 records. I am showing 20 items per page with previous and next page options. The search results can have any number of records. How can I make my access faster so that it show the first page without much delay and also while navigating to previous or next page the delay is minimum. Please suggest a solution.