Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #130

Re: CachedRowSet Alternat

Show all headers | View raw

  To: comp.lang.java.databases
On May 19, 7:24 am, "cksanj...@gmail.com" <cksanj...@gmail.com> wrote:
> 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

I would heartily recommend you do your joins and all other data
sifting
where the data is, in the DBMS, not in some external Java client. The
DBMS has all the code and power to do that stuff fast and correctly.
Never export huge swaths of raw data out of the DBMS. You build your
sawmill where the trees are.
Joe Weinstein at Oracle/BEA Systems

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: CachedRowSet Alternat joeNOSPAM@BEA.com.remove-dii-this - 2011-04-27 15:21 +0000

csiph-web