I have a C# application that connects to a FileMaker Server 17 database via ODBC. In general it works as expected but it takes up to 10 seconds to open the connection. The same happens if I create a System-DNS and perform a Test - even if I test it on the same machine. Is there a reason for this long delay and is it possible to optimize it somehow?
Best regards
Michael
Thanks a lot for the hint. In the past I actually used the CWP API to fetch data from FileMaker. One reason I do not like this approach is the fact that you have to prepare special layouts for it. This makes the handling for my app a lot harder as it should be. I perfer a more generic way of accessing FileMaker data. I will have a look at the long-running queries log but as the problem happens during connection and not during a query i do not really believe this will help.
Do you happen to have externally-authenticated accounts in your FileMaker database? I've seen a situation where a 10 second delay for external calls was eliminated by changing the authentication order so that the account being used came before any externally-authenticated accounts.
You could consider not using ODBC and use the fmDotNet library for interacting with FMS (do a search on it on GitHub, fmDotNet is available as NuGet packages for easy installation).
As to why it is slow: not sure. Do you have the DSN configured to log long-running queries? If so: do those provide a clue?