jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Stored Procedures and arrays Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored Procedures and arrays" Watch "Stored Procedures and arrays" New topic
Author

Stored Procedures and arrays

John Ryan
Ranch Hand

Joined: Mar 14, 2001
Posts: 124
Hi all,
I have written a Java stored procedure which i am using to insert information into my database. I have created an SQL user defined object that holds the details of one piece of information to be inserted. I have then created an SQL user defined array which holds a number of the user defined objects. From my Java code i then cal the stored procedure sending it an array of objects.
All this works fine. However i am wondering what the optimal size is for my array. i.e. how many objects should i send in each call to the stored procedure. I was hoping to speed up the time it takes to load a large number of these objects.
Can anyone give me an indication of the factors that affect the speed of executing the stored procedure how the size of the array i am sending can affect speed.
thanks,
John
 
 
subject: Stored Procedures and arrays
 
Similar Threads
How do I execute a SQL Server Stored Procedure with Hibernate?
Stored procedure call removes spaces in text
passing 2D arrays to Oracle Stored Procedure with/without using JPublisher
Problem using Callable Statement
How to pass class object in call to pl/sql procedure ?