CachedRowSet Alternative

[cksanjose]

Hi! I'm working on an application that uses CachedRowSet that queries
a DB2 database. One of the reasons it is using the CachedRowSet is for
creating a JoinRowSet based on certain criteria. The dataset that I'm
working on is quite large, between 20 - 25,000 rows. My problem is
that I'm always running out of memory because of the size of the
dataset.
Is there an alternative to CachedRowSet that can hold 25K rows and
implements Joinable?

Thank you for your help.
Cesar

 

[Arne Vajhøj]

Hi! I'm working on an application that uses CachedRowSet that queries
a DB2 database. One of the reasons it is using the CachedRowSet is for
creating a JoinRowSet based on certain criteria. The dataset that I'm
working on is quite large, between 20 - 25,000 rows. My problem is
that I'm always running out of memory because of the size of the
dataset.
Is there an alternative to CachedRowSet that can hold 25K rows and
implements Joinable?

You can't just increase the Xmx value ?

Arne