×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Request for help -Access 2007, Attachmate, VBA - Performance Issues

Request for help -Access 2007, Attachmate, VBA - Performance Issues

Request for help -Access 2007, Attachmate, VBA - Performance Issues

(OP)
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...  

RE: Request for help -Access 2007, Attachmate, VBA - Performance Issues



hi,

Quote:

considering that there are default wait times
I use no fixed default wait time.

The technique that I use to "wait" for the asych ready, is to move the cursor away from the screen rest coordinates and LOOP until the WaitForCursor is TRUE for the screen rest coordinates, like...
[code]
    With oScrn
        '...
        .MoveRelative 1, 1, 1
        .SendKeys ("<enter>")
        Do Until (.WaitForCursor(4, 3))
            DoEvents
        Loop
        '...
    End With
[code]
 

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Request for help -Access 2007, Attachmate, VBA - Performance Issues



BTW, since ALL my Attachmate applications read/write data FROM Excel, I do ALL my coding in Excel VBA, which is MUCH easier and MUCH more flexible in almost every way than Extra Basic.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Request for help -Access 2007, Attachmate, VBA - Performance Issues

(OP)
Hi Skip,

Thank you for your time...

There is no problem with the wait times... I have declared them as you have mentioned itself.

Also, the code works fine till 100 -150 records...post which it slows down drastically... I donot see a problem with the code since its the same steps that are being followed to update them on attachmate...
So, I am not sure where this is going wrong...!!! :(

RE: Request for help -Access 2007, Attachmate, VBA - Performance Issues



Quote:

There is no problem with the wait times
Hmmmm???

Are you sure?

I run using this technique and a simple screen scrape (24x80) of 1000 items (some items with multiple screens) runs 26:36 with no noticable cycle degredation.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close