AnsweredAssumed Answered

Slow query using ODBC and MS Query

Question asked by shootmenow on Mar 5, 2010


Slow query using ODBC and MS Query




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,