Execution time varies for same script.
Question ID: 107701

I’ve scripted a database script and we’re executing it daily. The execution time varies vastly for eg. Mon it would be 15 mins and tue it would be 23 mins. Can someone help me with this issue.

Marked as spam
Posted by (Questions: 22, Answers: 6)
Asked on July 12, 2017 4:55 pm
Answers (1)
Private answer

With out reviewing the GUI code, I can not tell for sure but I would have to say the issue is a performance issue related to network, backups, antivirus scans, or Database event/ issues. Recommend talking to the network and database admins to see if there was and event running during the time frame of the database queries? Also, I would recommend looking into using API testing to do database testing because it is compiled into a dll and runs directly instead of VBScript interpreted code making calls to COM ODBC connections.

The only documents I can recommend is:

1. UFT User Guide > Part 8 > Chapter 54: API Test Creation Overview
2. UFT User Guide > Part 8 > Chapter 55: Standard Activities > Database Activities > page 2066

Most of the time I find constructing a Database test with UFT API is faster and easier that attempting with GUI and VBScripting if the only thing being done is a database action.

Marked as spam
Posted by (Questions: 2, Answers: 98)
Answered on July 12, 2017 4:56 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top