Linereekido
New Member
I can't seem to find much help on this. I'm using the autocomplete extender in .net to suggest options for search box when user adds keystrokes to search textbox. This works fine, although a new call to the DB is sent every time a key is pressed.This is fine until the number of website users start to get high! So I used the cache with datatable.select instead of making a round trip to the DB everytime.If the cache does not exist, it is created, and then everytime after that the cache is used.However, the issue now is that all the users that arrive while the cache is being created by the first visitor assume there is no cache and start trying to create their own cache of the same name, thereby overloading the DB again!Are there any pointers on the best way to get round this? Thanks,Ben