I'm working with the Quickbooks ODBC for the first time. This is in the RightSource remote desktop environment, using Quickbooks Premier Manufacturing and Wholesale edition. The ODBC is the read only version from Flexquarters.
The response of queries with joins is very very very slow. Query the Bill_line table and the recordset comes back in 5 seconds. Join the ItemInventory table with the LineItemRefListID=ListID and the recordset comes back in 80 seconds.
Have you seen the same behavior? Do you have a way around it?
Thanks,
Jim