0 Replies Latest reply on Oct 29, 2012 6:55 AM by MayankSharma

    FMS 12 ODBC slower than FMS 11.

    MayankSharma

      Summary

      FMS 12 ODBC slower than FMS 11.

      Product

      FileMaker Server

      Version

      12

      Operating system version

      Windows Server 2008

      Description of the issue

      We have been using FMS 11 for our .NET applications. We are currently in the testing phase of upgrading to FMS 12 and noticed there is a significant delay of 20 seconds when the .NET applications first create a connection with a database on FMS12 when compared to FMS 11. If we re-query immediately after the the first query is served from the server, it is fast but if we wait a few minutes and do it again, the server takes about 20 seconds to respond. This happens for each connection to the server, so if have have 3 connections on a .NET web page going to three different databases, it will take 60 seconds.

      ODBC Driver: 12.2.94.0

      Steps to reproduce the problem

      using (OdbcConnection connection = new OdbcConnection(connectionString))
                  {            
                      string query = "SELECT * FROM \"

      \"";
                      OdbcCommand command = new OdbcCommand(query, connection);
                      command.CommandText = query;
                      OdbcDataAdapter da = new OdbcDataAdapter(command);
                      DataTable dt = new DataTable();
                      da.Fill(dt);
                  }