wood burning stoves
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored Procedures and arrays" Watch "Stored Procedures and arrays" New topic

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.
I agree. Here's the link: http://aspose.com/file-tools
subject: Stored Procedures and arrays
It's not a secret anymore!