• 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