I have a FM Database solution that is targeted for FM Go apps.
It is a data separation model solution with lots of reference to ESS tables from SQL Server.
So I have the reference to ESS data sources in the Data file and does all the operations I need to in the Data File and
a User Interface file.
Also I call a lot stored procedures that I call from my Data File based on various user actions.
Everything is working fine, no issues.
My problem is every time the user goes idle and tries to reconnect, it is taking along time to connect to the remote files.
It takes about 30 -40 seconds to reconnect.
What could be the possible reason for this and how can I minimize that.