Slow Performance

[ldoodle]

Hi,

Ever since upgrading to FileMaker Server 9 and Pro 9, performance is very slow on some larger databases.

Lowest spec PC here is an Athlon 3400+ with 512MB RAM.

Network is 100MB Full Duplex with 2-3 clients at any one time.

The databases (7 in total) were upgraded from v5, and read somewhere about old file/ip references - How do I check these?

Before the upgrade, the files were hosted on a client pc, as opposed to a dedicated server.

Thanks/...

Edited September 10, 2007 by Guest

[Steven H. Blackwell]

Lowest spec PC here is an Athlon 3400+ with 512MB RAM.

This is the Server? If so, this is so far out of spec as to be unbelievable. Pentium 4 or Xeon, 2 GB RAM, and SCSI or SAS hard drive please.

File references could be an issue. You use MetaDataMagic from New Millennium to identify and consolidate these before conversion.

HTH

Steven

[ldoodle]

No no no!!

That is the worst spec PC. The Server is a Core 2 Duo E6600 with 2 GB RAM and 2x 160GB SATA in RAID1, serving 3 clients.

Can the references not be sorted out after conversion as the client has been using the new one for over a month now, so going back to fp5 files is not an option.

[Ender]

File references can be fixed post-conversion, but it can be a lot more work.

You can examine the file references under File->Manage->External Data Sources.

Within each External Data Source definition, if there are old references, duplicate references, or references to the wrong directory, they can be consolidated and set to a single correct path. Use a relative path for files on the same machine.

If there are multiple External Data Source definitions for the same file, they can be consolidated by going through all your scripts, table occurrences, and value lists, and changing their source to be the "correct" file reference (external data source definition). Once they are all changed, you can safely delete the old External Data Source definition. If you delete an External Data Source definition that's still in use somewhere, the script, calc, or value list that refers to it will show "

[Steven H. Blackwell]

That is the worst spec PC. The Server is a Core 2 Duo E6600 with 2 GB RAM and 2x 160GB SATA

Still pretty anemic.

Steven

[Steven H. Blackwell]

File references can be fixed post-conversion, but it can be a lot more work.

Right on that. And the chances for errors are much higher as well.

Steven