[QODBC ALL] - How to know the time taken by QuickBooks SDK and QODBC.

Problem Description:

I would like to analyze how much time QuickBooks SDK takes to process the data request and how much time QODBC takes to format the data and send it back to the calling application.

This information will help us troubleshoot the slowness of the SQL statement and find out the cause of the slowness.

Solution:

You can use the "sp_tablesusageinfo" command to know the time taken by QuickBooks SDK and QODBC.

The "sp_tablesusageinfo" command is available in QODBC build 353 and above.

Usage

sp_tablesusageinfo ALL

The above command will list all the tables and their statistics

sp_tablesusageinfo <TableName>

example: 

sp_tablesusageinfo Invoice

The above command will list the "Invoice" table and their statistics

sp_tablesusageinfo <TableName> Reset

example: 

sp_tablesusageinfo Invoice Reset

The above command will reset the statistics of the table "Invoice".