Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Qodbc and MSSQL |
Author |
Message |
|
Posted : 2009-01-23 03:35:42 |
I have setup mssql to use qodbc as a linked server. The issue I am having is with query times. At one point during my testing, I was able to get results 1 time. The query took about 3 mins to process. Now the query its self is extremely simple, so I know this is not the issue. The table that I am querying against is extremely small, it only contains 3 records.
Last night before I left my office, I let the query run again, so I could see how long it took to run it a second time. I come into my office today to find it still running. 17 hours and 37 mins to be exact on the time it has been running.
Anyone have any suggestions on what might be causing this?
This is the query that I am using. SELECT * FROM OPENQUERY(QODBC, 'SELECT ListID, Name FROM Customer') |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-23 10:18:27 |
Try running:
SELECT * FROM OPENQUERY(QODBC, 'SELECT ListID, Name FROM Customer unoptimized') |
|
|
|
|
Posted : 2009-01-24 04:25:52 |
Same exact issue, the queries are to slow. I have read just about every post on linked servers I could find, and not a single one changed the query times.
This is the output from my qb log file. 20090123.102355 I 1548 RequestProcessor ========= Started Connection ========= 20090123.102355 I 1548 RequestProcessor Request Processor, QBXMLRP2 v7.0 20090123.102355 I 1548 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-25 16:43:58 |
|
|
|
|