title: Java handling large amounts of data
body: <p>I have a Java application that needs to display large amounts of data (on the order of 1 million data points). The data doesn't all need to be displayed at the same time but rather only when requested by a user. The app is a desktop app that is not running with an app server or hitting any centralized database.</p>
  
  <p>My thought was to run a database on the machine and load the data in there. The DB will be read only most of the time, so I should be able to index to help optimize queries. If I'm running on a local system, I'm not sure if I should try and implement some caching (I'm not sure how fast the queries will run, I'm currently working on them).</p>
  
  <p>Is this is a logical way to approach the problem or would there be better approaches?</p>
  
  <p>Thanks,
  Jeff</p>