so slow in network

[miszczyk]

Hey, I've written some dbs in FMP - but this is first time when use one in a network. It is not complicated, but works so sloooooooowly (having just 3 comps) - it takes about 6 sec to perform all scripts.

DB exists in a server (NT 4.0) - it is run as a host and opened by 2 users as guests.

All db consists of 5 files (in FMP called databases). Calculation requires to find some data in other files (using perform external script) and then returns to original file. Why it is so slow?

I noticed that being a guest - even when I had opened the other file before (having two files opened) - performing an external file - it reopens the file again from the server (host) and this takes some time, too. Why?

Any tips, appreciate...

Robert, NYC

[keshalyi]

One thing to check, and I don't know if this is the issue -

Uptake on cross-database calculations, etc, is considerably sped up if you keep all the databases open on the client computer. So, when they start the database, have it script out to open (hidden, probably) the other linked databases. This way, you have the data, on hand, and it doesn't have to go crying to the server, or wait for the database to launch, or whatever.

[Vaughan]

Databases are automatically opened when needed -- no need to open them all at start.

FMP is very disk intensive: this translates to network intensive for multiple users. Check your network type, routers, hubs etc.