FMP 12 DB as an external data source ... 30 second pause ...
I have a FMP 12 Database that uses a second FMP 12 Database as an external data source. The second DB contains about 3,500 records.
In the application I have it defined in the relationship graph. The second database resides on another server, running FMP 12 Server and is accessed via the internet.
There seems to be an "event" occurring once that causes a 30 - 40 second delay ... Tea cup present. I have a button in the app that calls a script that simply lists names from the external source. Once selected it populates inof about the person.
Even if I do not activate the script, the pause will occurr once after launching the application. I can duplicate the pause by trying to use database manager, or modifying a field.
Is there caching that is being done and this is somethign to expect or is it a config issue?
Accessing the second database normally does not experience the pause.