Application Note for QuNect ODBC for QuickBase

Minimizing API calls with QuNect ODBC for QuickBase

Use the DOQUERYCHUNKSIZE connection string parameter to increase the number of records returned per API_DoQuery API call from the default value of 1,000. If you set this value too high then you QuickBase will respond with error number 75, "View too large". Then QuNect ODBC for QuickBase will try again asking for half the number of records. This will be repeated until Quickbase stops responding with error 75. This retry process will actually increase the number of API calls per record retrieved rather than minimizing the number of API calls per record retrieved. So the records per API_DoQuery call must be set with caution to make sure you don't encounter error 75. QuNect ODBC for QuickBase API and SQL logging will help you determine if you're encountering error 75's. You can also use the more convenient "Optional Advanced Features" "API_DoQuery Chunk Size" setting at the bottom the DSN dialog to do the same thing.