AnsweredAssumed Answered

FMS 12 ODBC slower than FMS 11.

Question asked by MayankSharma on Oct 29, 2012

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);
            }

Outcomes