Intriguing situation here... I have a program on a Unix box that performs the following:
This is basically a pointer to the data once it is run.
Program then does:
The data set retrieved is about 48k records. When running this for 1 store, the job runs and completes in about 3 minutes (There are 5 different data sets it pulls to update Derby Database Tables)
The Lib.Table is indexed on StoreNo as the Primary Key.
When I run 15 of these jobs concurrently, it takes over 30 minutes to complete all 15. Which seems to point back to the JDBC pulling data. Could the be due to the index on the table? Or, is there a Share Access Path that I'm missing here?
Let me know
PHP Code:
Select F1, F2... Fx
From LIB.Table
Where StoreNo = <StoreNo>
Program then does:
PHP Code:
Insert into
DBUser.Table
(F1, F2, ... Fx)
Values
(?, ?, ... ?)
The Lib.Table is indexed on StoreNo as the Primary Key.
When I run 15 of these jobs concurrently, it takes over 30 minutes to complete all 15. Which seems to point back to the JDBC pulling data. Could the be due to the index on the table? Or, is there a Share Access Path that I'm missing here?
Let me know