Re: Stored procedure execution: From JDBC calls vs Direct

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 08 Feb 2004 09:04:37 +0100
Message-ID: <7arb20phab108j22h0ic6fafsepbp8hcn8@4ax.com>

On 7 Feb 2004 21:46:29 -0800, rob_roh_at_hotmail.com (Robert Roh) wrote:

>If these requests were spooled to a file system first and I then
>executed the stored proc from PL/SQL by reading in say request data
>for 1000 requests at a time, would this process be much faster or
>about the same.

It would be a horrible solution, given the fact PL/SQL can read only 1 line at a time, and consequently the performance would be slower. What are you up to and what horrible architecture do you have already implemented?

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Feb 08 2004 - 02:04:37 CST