We got Quick Books Enterprise Solutions - Professional Services Editon 6.0 & SQL Server 2005 (Express) and Running QODBC as a Linked server. Queries are real slow (& inconsistent as far as the time is concerned). Simple query(s) like
SELECT ListID, Name FROM QODBC...CustomerSELECT * FROM QODBC...HOST SELECT ListID, Name FROM QODBC...Employee SELECT * FROM OPENQUERY(QODBC, 'SELECT ListID, Name FROM Customer') SELECT ListID, Name FROM QODBC...Customer SELECT ListID, Name, CompanyName FROM QODBC...Vendor SELECT * FROM QODBC...CustomField
sometimes take more than 4 mins. Sometimes do return results within a minute - kind of inconsistent. The query is being run from SQL Studio.
I have created views in SQL DB on tables from QODBC. It is the same issue with these views - inconsistent query result return time.
We are evaluating this set up for a project. If this works reasonably are considering buying these products. Any help is appreciated.
Thanks in advance. |