Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: limiting result set size

Re: limiting result set size

From: Paul de Anguera <nospam_at_quidnunc.net>
Date: 2000/03/13
Message-ID: <8ahh3f$54e$5@news.chatlink.com>#1/1

In article <38CC09AC.C8488141_at_home.com>, Matt Brown <mbrown1_at_home.com> wrote:
.. I plan on having a scalable java application
>which will process rows from a table. 1..n of these applications could
>be deployed to distribute the processing.
>
>Each application will need to execute a query or call a stored procedure
>to get a set of rows to work on. What's the best way to accomplish
>this?...

The trouble with parallel processing is that you become CPU-bound unless you have lots of processors. I'd consider it only if the threads need to do some more I-O, so the CPU can run some threads while others are waiting for I-O. Otherwise you're just cutting the problem into smaller pieces and getting more overhead and complexity for your trouble.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa
Received on Mon Mar 13 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US