Local Cacheing of data from database and using it

[raja patil]

Hello,

I am new to java and writing my first spring, ibatis, blazeDS, flex 4 application.
In a Remote Object service method I am firing a query returning a large dataset and collecting it into a arraylist.
Then I am iterating through that list and refering other data from database over and over again. This is giving me
a performance hit since for every query there is connection and data retrieval overhead. Since the referred data is small
is it possible to store it in local in memory database and retrieve it by using multiple fields ?

Earlier when I was coding in delphi we used to use in memory tables with many fields and in the beginning of large
processing we used to query RDBMS for those table and save data in memory tables then fire main query
which was returning large dataset and the we were iterating through that dataset and whenever reference data was
needed we used seek memory tables with required fields and get the reference record for further manipulation.
this technique was giving us lot of performance improvement.

I would like to do same in java how can I do that ?

Thanks and best regards

Raja

[Jeanne Boyarsky]

Raja,
You can use Spring to set up caching with EH Cache. See spring caching for articles and examples.