0 Replies Latest reply on Mar 5, 2010 1:28 PM by shootmenow

    Slow query using ODBC and MS Query



      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,