This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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

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.
Have you checked out Aspose?
subject: Stored Procedures and arrays
jQuery in Action, 3rd edition