Databases
StackOverflow2013
Postsdbo
POUsing hibernate as backing for large dataset in JTable
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing hibernate as backing for large dataset in JTable
    primarykey
    data
    text
    <p>Have an application that has a Jtable with the data held in RAM, the table can upto be 1,000,000 rows by 100 columns so this just uses too much memory. So now I'm moving to backing the JTable from a database, but I think getting directly from JTable to database is not going to help much because either all the data from the database is going to get loaded into memory when jtable initilized , or as the user scrolls down the tabel I would do select staements to get the next data, which would be too slow, and how would I handle sorting.</p> <p>So I think the correct solution is to stick Hibernate between the JTable and Database, but I still can't quite see how this is going to help with a really large JTable. </p> <p>Can anyone point me to a good example / have experience of using this with large dataset to keep memory usage down.</p> <p>EDIT:Ive read some comments on other threads that a table with this much data should have filters so that only a subset of data is ever shown. I agree with that as a general principle and I will provide a filter HOWEVER only the user can decide how they want to filter it, and I still need to provide a 'ALL' option, and this is where it could all blow up.</p> <p>I also remember something about having one table on top of another showing some kind of subset of the data that changes as you scroll down, but not seen a concrete example of this idea.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkleopatra
    1. USPaul Taylor
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing hibernate as backing for large dataset in JTable
      1. USPaul Taylor
      1. VTBountyStart
    1. COSee also [Do you know of a sophisticated spread sheet like component for Swing](http://stackoverflow.com/questions/7663990/do-you-know-of-a-sophisticated-spread-sheet-like-component-for-swing). The [JPA](http://en.wikipedia.org/wiki/Java_Persistence_API) layer can make paging easier.
      singulars
      1. POUsing hibernate as backing for large dataset in JTable
      1. UStrashgod
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload