Knowledgebase: Microsoft Products
[QODBC-Desktop] Troubleshooting: Slow Performance with Excel MS Query
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: Slow Performance with Excel MS Query

Problem Description

I am experiencing a huge delay when running a Query in the Excel MS Query versus running the same script in VB Demo. VB Demo will return the data in 2 seconds while running the query in MS Query running for over 10 minutes. I am running Optimizer. Is something not configured correctly?

Solutions

MS Query builds queries a little bit differently than I would write them. Copy the SQL Statement from MS Query into VB Demo and re-compare what's really going on. The actual query part should be the same, but the passing of data to Excel from MS Query would take additional time depending how much data is returned.

The best optimizer settings should be checking "Optimize data after an Insert or Update" and "Dirty Reads" option. See also: How to setup QODBC Optimizer and where are the Optimizer options for more.

 

Keywords: qodbc and excel connection speed, multiple web queries into excel slow running

 

 

(128 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).