• Post Reply Bookmark Topic Watch Topic
  • New Topic

Local Cacheing of data from database and using it  RSS feed

 
raja patil
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 37518
554
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Raja,
You can use Spring to set up caching with EH Cache. See spring caching for articles and examples.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!