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

    Slow query using ODBC and MS Query

    shootmenow

      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