[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.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".
| |
|