VBAInterest
IS-IT--Management
Hi All,
I need your help on a project that I am currently working on. I am using Microsoft Access 2007 to write information to Mainframe Systems using Attachmate Extra X-treme 8.0 (SP1).
The code is running fine. However, I am facing an issue when it comes to certain files (where the number of records to be written to Mainframe are more). If there are 100 records, the code works fine and writes to Mainframe in about a minutes time (which is good enough considering that there are default wait times).
However, when the number of records are more the macro slows down gradually... A file with 700 records took 38 minutes, 19 minutes and 21 minutes when ran simultaneously.
A point to note is that the macro is run over a Citrix Session. I understand that there may be variations in the connectivity. However, this difference between the time taken to update 100 records vs 700 records is alarming.. (1 minute vs 20 minutes average)
I have tried running the code with and without disabling the Productivity Tools on Attachmate (Disabling Screen History, etc..) and still there is no change in performance....
Any help that you can provide me in resolving this issue will be greatly appreciated.
Best regards...
I need your help on a project that I am currently working on. I am using Microsoft Access 2007 to write information to Mainframe Systems using Attachmate Extra X-treme 8.0 (SP1).
The code is running fine. However, I am facing an issue when it comes to certain files (where the number of records to be written to Mainframe are more). If there are 100 records, the code works fine and writes to Mainframe in about a minutes time (which is good enough considering that there are default wait times).
However, when the number of records are more the macro slows down gradually... A file with 700 records took 38 minutes, 19 minutes and 21 minutes when ran simultaneously.
A point to note is that the macro is run over a Citrix Session. I understand that there may be variations in the connectivity. However, this difference between the time taken to update 100 records vs 700 records is alarming.. (1 minute vs 20 minutes average)
I have tried running the code with and without disabling the Productivity Tools on Attachmate (Disabling Screen History, etc..) and still there is no change in performance....
Any help that you can provide me in resolving this issue will be greatly appreciated.
Best regards...