# Performance: A command line tool to analyze web form response times

**URL:** <https://discuss.workflowgen.com/t/performance-a-command-line-tool-to-analyze-web-form-response-times/415>\
**Category:** Performance\
**Created:** [October 17, 2013, 2:42am UTC](https://discuss.workflowgen.com/t/performance-a-command-line-tool-to-analyze-web-form-response-times/415 "2013-10-17T02:42:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wfg-admin](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/wfg-admin/32/714_2.png) [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\
**Post date:** [October 17, 2013, 2:42am UTC](https://discuss.workflowgen.com/t/performance-a-command-line-tool-to-analyze-web-form-response-times/415/1 "2013-10-17T02:42:26Z")

</div>

To analyze web form response times, you can use the Log Parser command line tool, available for download at [https://www.microsoft.com/en-ca/download/details.aspx?id=24659](https://www.microsoft.com/en-ca/download/details.aspx?id=24659).

This tool is useful when you want to isolate bottlenecks and performance issues. It relies on IIS logs and generates reports.

Here’s a command line example:

```auto
logparser -i:W3C "SELECT TOP 30 [cs-uri-stem], MAX([time-taken]) AS MaxTime, MIN([time-taken]) AS MinTime, AVG([time-taken]) AS AvgTime INTO LogParser.csv FROM c:\temp\logs\*.log GROUP BY [cs-uri-stem] ORDER BY AvgTime DESC" -o:CSV

```

| cs-uri-stem | MaxTime | MinTime | AvgTime |
| --- | --- | --- | --- |
| `/wfgen/wfapps/webforms/IT_REQUEST/V1/Default.aspx` | `1357` | `574` | `877` |
| `/wfgen/wfapps/webforms/CHANGE/V1/Default.aspx` | `703` | `546` | `624` |
| `/wfgen/wfapps/webforms/EXPENSE/V1/Default.aspx` | `996` | `761` | `881` |
| `/wfgen/ws/processesruntime.asmx/GetLaunchableProcessList` | `716` | `156` | `242` |
| `/wfgen/wfapps/webforms/INVEST/V1/Default.aspx` | `3250` | `2906` | `3078` |
| `/wfgen/wfapps/webforms/LEAVE_APP/V1/Default.aspx` | `775` | `78` | `569` |