I am having an autocomplete textbox that should show records starting with whatever the user inputs. For example when entering "a", I want to get all customers whose name starts with "a" from the database and show in a GridView.
The problem is that more than 10000 records start with "a".
like suppose if i am displaying 10 or 20 records in gridview then for next 10 or 20 records i dont want roundtrip on database.i want to fetch that next 10 or 20 records from cache or any other altrenative if you can suggest.
What I am thinking about is to load that data in cache memory and get from cache memory. Will this improve performance?
And if so, how will I implement and use this cache?