[QODBC ALL] - How to know the time taken by QuickBooks SDK and QODBC
Posted by Rajendra Dewani (QODBC Support) on 02 November 2023 12:03 PM
[QODBC ALL] - How to know the time taken by QuickBooks SDK and QODBC.
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.
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.
The above command will list all the tables and their statistics
The above command will list the "Invoice" table and their statistics
sp_tablesusageinfo <TableName> Reset
sp_tablesusageinfo Invoice Reset
The above command will reset the statistics of the table "Invoice".