This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedures and arrays

 
John Ryan
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic