Hi,
I wrote some java jdbc code to fetch the data from the database and store it in an xml document .This xml document is updated for every 24 hours.
When ever a search query comes i need to search in the xml file for the given data.
I want to know whether this is an efficient/good way to do searching , to avoid database call every time a search request comes.
Or storing the data in hashmap (key=column1,value=column2) and searching in them improves performance.
I will at most 25000 rows in the database.
Thanks in advance