Jump to content

Slow Performance


This topic is 6120 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 "

Link to comment
Share on other sites

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.