Two common "slow connection" issues you can check:
- Look for bad IP address references. If an external source refers to a file via a bad IP address and a subsequent line in the same reference correctly references the file, filemaker takes an extremely long time to figure out that the IP address is bad and then tries the next path in the reference.
- Look for any references with * in them. Remove those, replacing them with specific IP address, DNS, or just a relative path reference.
Do you have a copy of filemaker advanced?
A database design report generated from advanced could be very helpful in cleaning up uneeded, duplicate or wrong external data source references. You can modify the name of an external data source rference to something very unique--like XXXXX and then create and search the DDR for all instances of this reference. You can then find and edit these references to remove cases where it's a "circular" reference or to use a different, identical reference so you can eliminate the redundant reference.
I do have Advanced and will run a DDR.
When you say "If an external source refers to a file via a bad IP address and a subsequent line in the same reference correctly references..." do you mean the external source of an external source?
If you open Manage | External Data Sources...
You can find entries like this for a single external data source:
Note that you have two paths to the same file in one reference. If this reference listed them like this:
And the IP address was invalid (maybe that server is turned off or no longer exists) but the relative path on the second line is valid, filemaker will open the file, but only after spending a very long time attempting to open the file via the invalid IP number.
Ok thanks for clearing that up.
I actually have cleaned out all External Data Sources to only include the fmnet:/ip.add.res.s/file.fp7 references on all the databases.
had to do this because my users have all been migrated to Snow Leopard.
I don't think the "circular reference" is an issue--it didn't seem to slow things down on my windows systems anyway.
Perhaps it's not the references at all. Do you have any scripts set in File Options to run automatically when the file is opened?