-
Dear gurus
We have a pl/sql procedure, which is used to process for datapumping, it processes 20 records per min, ... we would like to improve the performance... we have tuned the code as much as possible to improve the performace with various aspects...
We have an idea, to post 4times same procedure with different arguments simultaneously, so it may improve performance 4 times (theoretically)...
Example:
Procedure1(ID1,Filename1) 20 rec processing the same time
Procedure1(ID2,Filename2) 20 rec processing
Procedure1(ID3,Filename3) 20 rec processing
Procedure1(ID4,Filename4) 20 rec processing
this is something like, the procedure has to be assigned in different worker / processor...
so, we need to have a controller script, which will control the operation of all those procedures, and once this process is completed for , it has to take next argument and processes..
Could someone throw some light on this...
regards
anandharaj
Anandharaj
a_anandharaj@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|