AnsweredAssumed Answered

Slow query using ODBC and MS Query

Question asked by shootmenow on Mar 5, 2010

Title

Slow query using ODBC and MS Query

Post

Hello,

 

I am trying to fix a problem where queries using Microsoft Query/Excel take more than four minutes to execute. I am only pulling 10 fields and about 1000 records at a time.

 

I have tried following the suggestion to add DataSourceWorkAroundsClient4=50 to the swandm.ini, but has not helped.

 

What else can I try to fix this?

 

I am using:

1. Filemaker Pro 10

2. Windows XP SP3

3. Database has four tables linked to each other.

4. I am a database expert with limited experience with Filemaker.

5. Filemaker is being shared over the network. However I am running this query locally.

 

Thank you,

Rishi

Outcomes