Execution time varies for same script.
| ♥ 0 |
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 |
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 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 bubblehead712 (Questions: 2, Answers: 98) Answered on July 12, 2017 4:56 pm
|