Speed

[slbr549]

Strongly recommend putting the FileMaker databases on a dedicated machine with FMServer. This will speed up your access considerably. The dedicated machine should have lots of ram. The machine I'm using currently has 512mb.

If cost is an issue, you can put FileMaker Pro and the database files on a dedicated machine with as much ram as you can afford. We ran our db's this way at a previous company I worked at. It's not as fast as FMServer, but it is definitely faster than hosting the files from your own computer.

[JPaul]

Hi Robert,

in the past, before using FMP Server, i tried to share db between two very slow ps's: they were 2 133 mhz and the master db was 20-25000 recs. with over 40 active relations & self joins.

Obviously things were pretty slow, but they changed as i saved files 'as compressed'.

This is the first step of db admin. to do periodically on large db's, primarily if they must receive a lot of transactions and have a lot of connected users.

Try this, before increase RAM or to change Hw.

Greetings from Holy Lands.

[Rhagerma]

We have several Filmaker pro 5 databases tied together. There are 5 of us sometimes trying to use them at the same time. It is VERY SLOW. Can anyone tell me a solution to this? Is there a network version we should use? Also when someone is the first person to open it everybody who opens it after that has to close it before I can close out of mine (because they are my "Guests") Please help.

Robert