ldoodle Posted September 10, 2007 Share Posted September 10, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted September 10, 2007 Share Posted September 10, 2007 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 More sharing options...
ldoodle Posted September 18, 2007 Author Share Posted September 18, 2007 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 More sharing options...
Ender Posted September 18, 2007 Share Posted September 18, 2007 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 More sharing options...
Steven H. Blackwell Posted September 18, 2007 Share Posted September 18, 2007 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 Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted September 18, 2007 Share Posted September 18, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6192 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 accountSign in
Already have an account? Sign in here.
Sign In Now