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.