Knowledgebase
[QODBC-Desktop] Troubleshooting : The Result Set Limitation in VB Demo
Posted by Wilson (QODBC Support) on 09 February 2012 06:33 AM

Why can VB Demo only display 10000 records

Troubleshooting: The ResultSet Limitation in VB Demo

Problem Description:

When running the VB test application only 10,000 records are returned from the table even thou there are more than 10K records in the table. Is that just a limitation to the VB Demo application or is there a limit to the number of records the driver returns?

Solutions:

QODBC does not have a limitation of 10,000 records. The record limit is on VB Demo. VB Demo is designed to show limited records and is just an application to test your queries or connection.

We would suggest trying other applications like MS Excel or MS Access; those applications can display all records from your table.

But trying to view more than 10000 records in one query is not suggested because QuickBooks has to allocate more memory for the entire result of the query in memory and to extract too many results at one time can get system very slow and sometimes crashes QuickBooks.

We would suggest to use separate queries or filter your queries to get blocks of data by date range or any other field whenever possible.

 

(9 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).