This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm implementing automcomplete in my struts 2 project. I have a list of around 15000 values in my database, which will be displayed as suggestions to the user. Now I am not really sure wheather I should fetch them everytime user enters a new letter in to the textbox. Because that will make the autocomplete very slow and of no real use to the user. As an alternate to that I was thinking of storing all the values in some scope of my application like Application scope because the auto complete will appear on each page of my project. But is that a good practice I'm not sure. So what can be the most efficient way to store these values so that the response of autocomplete is good and can be helpful to the users. Thanks for your time and efforts.