Stored procedure execution: From JDBC calls vs Direct

I have a large data stream (about 10,000 requests every 5 minutes) currently handled by a Java program that uses a connection pool. Each request invokes a stored procedure execution using the connection pool.

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.

Thanks
Robert Received on Sat Feb 07 2004 - 23:46:29 CST