Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: limiting result set size
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 ZappaReceived on Mon Mar 13 2000 - 00:00:00 CST