Slow database launch time

[VR1]

I have a 20 file related database that we recently upgraded from FM 5.5 to FM 7.03. In FM 5.5, the database files would all open in 10 seconds. In FM7, this is a 3 to 4 minute ordeal. The database consists of one main file and 20 related files. The initial open script in the main file simply opens all related files and switches to the main layout. No today calculations (or any calculations) in the open script for any of the files. All file references have been edited to look first over the fmnet, then the local folder. All files live in one folder and slow loading occurs whether launching on the server from the hard drive, or opening the database from a guest workstation over the network.

 

Debugging the main file's open script reveals that regardless of file size (a few hundred or few hundred thousand records) each file requires about 10 to 12 seconds to open.

 

Once open, the database functions normally with no appreciable sluggishness.

 

Thoughts on what is causing the painfully slow launching of the files? Thanks

[Henk B]

Obsolete File references?

[Ted S]

Yeah, take a look at the file references: FILE -> DEFINE -> FILE REFERENCES...

 

Clear out any old references. This made my system run a lot faster. And its was fun to take a walk down memory lane.

[VR1]

Thanks for the suggestions on file references, but they have been optimized.

 

Other known causes for slow database start up?

[Vaughan]

"All file references have been edited to look first over the fmnet, then the local folder."

 

Change the order so they look in the local folder first.