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

 

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).