QODBC is a very fast ODBC driver, especially when you realize there's no database here. There's no SQL Server here. The QuickBooks interface SDK, which uses XML, is not the speediest file system available, but it does the job. The QODBC driver works with all front-end applications which can access ODBC, some of which are faster than others. QODBC converts a SQL statement to an XML Request which is sent to Intuit's qbXML SDK which is then processed by the QuickBooks application and a XML Document returned and QODBC strips out all the XML tags and returns you the data.
For this reason we added the QODBC Optimizer which is a SQLite Server that runs at a user (workstation) level. If you add a NOSYNC to your SELECT query, things run much faster:
select * from InvoiceLine NOSYNC WHERE Txndate > {d '2008-04-01'}
Unfortunately, it can't do anything about INSERTs. |