How to capture response time?

LegacyForum

While running the regression controls in SOA for each operation, we are giving some 100-200 inputs. And for each we can see the response time as well. Is there any default method, by which we can capture these response times per input and export them into an excel sheet.

LegacyForum

Hello,

What is your goal in exporting the response times?

You may want to look into SOAtest's load testing features. Load testing may help you achieve you goal.
It will allow you to capture the response times and other performance data.
You can then export the performance data and import it into Excel.

Please let me know if you have any additional questions.

~Joe

LegacyForum

Ok. We have some different sets of inputs, which will fetch the data from the different tables in the same database. So it's like one input would get the data from one table, but another input will take the data from 2 or 3 tables as the case may be. So depending on the response time that each input takes, we can try to tune from SQL procs.

I got some scripts for getting the response time from another post in the same forum. "SOA Test:Transaction Time, Transaction Time for each Tests"

1. Chain to the Request SOAP Envelope a Method tool with the following Python implementation:

from com.parasoft.api import Context
from java.lang import System

def putTime(input, context):
context.put("Test time", System.currentTimeMillis())

2. Then to the Response SOAP Envelope, chain another Method tool with the following Python implementation

from com.parasoft.api import Context
from com.parasoft.api import Application
from java.lang import System
from java.lang import Long

def printTime(input, context):
t = context.get("Test time")
diff = System.currentTimeMillis() - Long.valueOf(str(t))
Application.showMessage("Total execution time: " + str(diff) + "ms")

I tried this and in the result am getting some different time. Please let me know which is the TOTAL EXECUTION TIME.

In the response, near the EXECUTION TIME I am getting 20734ms, where as the above method in the result is displaying 16ms.

So I was just wondering what exactly is the time, thats being measured by the above method. and which time should be considered as the actual response time.

Find the attachments The one in the blue box at the top is given along with the response, but the one below, i got by using the methods given above.

Shyam!

LegacyForum

Hello,

In looking at the screen shot. I see that the 2 method are both chained to the Request. One should be chained to the response.

Alternatively, you could chain a method tool to the Traffic Object and do this:

CODE

def printTime(input,context):
reqTime = input.get("XML Request Time").getTime()
respTime = input.get("XML Response Time").getTime()
Application.showMessage(str(respTime - reqTime))

Please let me know if this works for you.

~Joe

LegacyForum

Hi,

Yes I chained one method to request and another to response. But still I can see some small differences in the values. This is not much a concern for me as what I need to know is approzimately how much time it took for the response to come back.

But still just for the information
Input 1 - Execution Time ( 19703 ms) But using the methods the time is 19735 ms
Input 2 - Execution Time (20171 ms) but using the methods the time is 20203 ms

I Also tried the traffic object method which you gave me, but I am getting some WRONG SYNTAX messages like shown below. So it's not getting enabled and it's not having any effect during the run. Please let me know what to do?

Traceback (innermost last):
(no code object) at line 0
SyntaxError: ('invalid syntax', ('<string>', 2, 1, 'reqTime = input.get("XML Request Time").getTime() '))

Regards,
Shyam!

LegacyForum

Hello,

The small differences in time is due to the time it takes to actually execute the method.
Using the traffic object should be more accurate.

I believe that error is due to indentation. Can you confirm that the code copied over to SOAtest correctly with the indentation on all but the def line?

~Joe

LegacyForum

Hi,

I tried the alternative method which you gave me. But even after I put in the format as you specified, it's giving some other error like "Traceback (innermost last): File "<string>", line4, in printTime NameError: Application". So I would require some more of your help in correcting this. I am not that very much familiar with python scripting.

However, using the first method given, this time I am getting very large difference in the times recored by the method and by SOA tool. Find the attached excel sheet in which I have put a sample comparison


No Response time as per method Response time in SOA
1 Total execution time: 63ms 47ms
2 Total execution time: 62ms 32ms
3 Total execution time: 47ms 31ms
4 Total execution time: 47ms 47ms
5 Total execution time: 31ms 31ms
6 Total execution time: 47ms 31ms
7 Total execution time: 47ms 31ms
8 Total execution time: 79ms 32ms
9 Total execution time: 31ms 31ms
10 Total execution time: 47ms 47ms
11 Total execution time: 62ms 46ms
12 Total execution time: 31ms 31ms
13 Total execution time: 62ms 46ms
14 Total execution time: 31ms 31ms
15 Total execution time: 46ms 31ms
16 Total execution time: 32ms 32ms
17 Total execution time: 47ms 32ms
18 Total execution time: 47ms 31ms
Test succeeded


THIS IS BECAUSE I WAS PREVENTED FROM UPLOADING THE EXCEL SHEET. """" Upload failed. You are not permitted to upload this type of file""""

Regards,
Shyam

LegacyForum

Hello,

You're missing the import required for the Application object. Sorry, I did not make it clear that it was needed.

The complete code should look like this:

CODE

from com.parasoft.api import *

def printTime(input,context):
reqTime = input.get("XML Request Time").getTime()
respTime = input.get("XML Response Time").getTime()
Application.showMessage(str(respTime - reqTime))

~Joe

LegacyForum

Thanks a lot..

this is working fine and giving the accurate results.

Thanks
Shyam

[Deleted User]

Can you please let me know the time format when retrieving the getTime method.
reqTime=input.get("XML Request Time").getTime()

What is the time format of reqTime value.

benken_parasoft

Please see the script I posted near the top of this thread:
https://forums.parasoft.com/discussion/3189/get-data-from-traffic-viewer-object

input.get(SOAPUtil.REQUEST_TIME) or input.get(SOAPUtil.RESPONSE_TIME) return a java.util.Date Object. Java has other APIs for taking a Date object and converting it to a string in a particular format. In particular, there is java.text. SimpleDateFormat which has a format(Date) method.