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

Re: CachedRowSet Alternat

Path	csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From	joeNOSPAM@BEA.com.remove-dii-this
Subject	Re: CachedRowSet Alternat
Message-ID	<1cbd225f-58ec-48a5-a9d9-7ac7cefd960f@f24g2000prh.googlegroups.com> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
In-Reply-To	<71b476e5-7a00-4be9-94ed-b08d65774bfd@25g200
References	<71b476e5-7a00-4be9-94ed-b08d65774bfd@25g200
Content-Type	text/plain; charset=IBM437
Content-Transfer-Encoding	8bit
X-Gateway	time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines	26
Date	Wed, 27 Apr 2011 15:21:55 GMT
NNTP-Posting-Host	96.60.20.240
X-Complaints-To	news@tds.net
X-Trace	newsreading01.news.tds.net 1303917715 96.60.20.240 (Wed, 27 Apr 2011 10:21:55 CDT)
NNTP-Posting-Date	Wed, 27 Apr 2011 10:21:55 CDT
Organization	TDS.net
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:130

Show key headers only | 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