very slow served databases in layout mode

November 26, 200718 yr

Hi,

FMS 9 on win XP, serves 2 databases currently these are accessed via a windows terminal server running FMP9. Still in test phase, so no clients logged in.

Performance seems ok generally, but in layout mode, some things slow to a crawl. click select a field then click delselect that field (i.e. click on layout background), takes 25 seconds to refresh/deselect.

Dragging a field 2 cms takes in excess of 2 mins. Working in the Relationship graph, is similarly impossible.

Have upped the FMS RAM allocation to 2GB, and additioanly reset the cache to 256MB, with largely imperceptible change.

The TS has 1.17 GB RAM

Any thoughts on this?

November 26, 200718 yr

I don't know what a Windows Terminal server is but clearly there's a major problem. Did you creating a new test database with only one or two fields? You might want to check some hardware diagnostics such as the network throughput the client/host cpu activity and hard disk read/write activity during database use.

November 26, 200718 yr

This is hardly an optimal or even recommended configuration.

1. You're using a workstation OS, not a server OS.

2. You've added a layer (Terminal Services).

3. You appear to be running FMS and TS on the same machine? That's not good either.

Try a more standard or recommended configuration and see what happens. Also, be sure that all versions are fully up to date with the latest v-rev.

Steven

November 26, 200718 yr

Author

1. You're using a workstation OS, not a server OS.

yes, but this is acceptable specification is it not? If this is contributing to limited performance, then it can be changed.

2. You've added a layer (Terminal Services).

Granted, but acceptable according to FM literature. Mind you the latest 'best practices' on FM site is a 2004 document.

The performance in browse is fine, the issue is in layout mode. One other quirk I have realised is that moving an object by using the arrow keys is reasonable, it is drag move etc. that is woeful.

3. You appear to be running FMS and TS on the same machine? That's not good either.

No, 2 separate machines as far as I know. (setup by IT) will confirm...