0 Replies Latest reply on Sep 25, 2006 7:45 AM by Ian Hunter

    Caching large volumes of entities

    Ian Hunter Newbie

      Hi Folks,

      We have a server designed to serve 'live' database data. We have now been asked to provide a facility for querying 'historical' database data from the database.

      I *think* that serving up large volumes of historical data would consume resources and slow down the live service. [I *really* think the historical stuff should be on another box but thats another fight.....]

      I propose to NOT use JBoss CMP, but to go straight to JDBC for these historical queries [the queries will also be paged for performance].

      Does anybody have similar experiences they can share, and any alternative ideas. For instance, can I destroy the cache for the historical data when the data has been sent to the client - if so, an example would be really great.

      Any ideas or comments appreciated

      Ian Hunter