title: QODBC SELECT taking > 15 minutes to return results
body: <p>I'm pretty new to using QODBC for QuickBooks reporting. One of the first SELECT queries I prepared essentially flags customers with existing unused payments in the ReceivePayment table, querying against invoices with remaining balance for that same customer. The output is (or should be) a list of customers grouped by CustomerRefFullName, with a sum of unused payments in column #2, and sum of total balance remaining from open invoices.</p>
  
  <p>It's a fairly simple query. When I import the table to MS Access as a static table, the query is fast as would be expected. However, when I run the query against a linked table, it takes upwards of 15 minutes to produce the results.</p>
  
  <p>This should not be happening. Is this a MS Access misconfiguration issue? Something else relating to QODBC configuration that I am missing or unaware of? Any help would be appreciated.</p>