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: 126.96.36.199
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();