Troubleshooting Project Databases
I deleted a lot of data from my project database, but the file size did not shrink.
The project database has to be defragmented to delete free space from the file.
•Click File > Info > Defragment Project Database after closing the project database.
Renaming objects in the project database takes a long time.
If you rename an object in a FlexPro project database, FlexPro searches the entire project database for objects that have references to this object in order to correct them. This can take a lot of time if the project database is large.
1.Click File > Options.
2.Click on the Operation tab.
3.Uncheck the option Search the complete project database when looking for references. FlexPro then searches only folders in which the renamed object is located.
FlexPro uses too much memory.
You can optimize the memory requirements for FlexPro and the runtime environment for the FPScript analysis language for your computer.
1.Click File > Options.
2.Click on the System Settings tab.
3.Under Maximum memory allocation for data sets enter a value that equals no more than 70% of the computer's available memory.
4.Under Maximum size of data sets in memory enter a smaller value. Usually, there are several small and some large data sets in a project database. The value that you set here should be somewhere in the middle. Note that the size of a data set in bytes equals in the number of values multiplied by the number of bytes per value. A 64-bit floating point value takes up 8 bytes, for instance.
5.Under Maximum number of folders in memory enter a smaller value. Try out different values to find the setting that provides optimum performance. Lowering the value has effect only if there is no connection in the form of object references between the folders in the project database.
6.Under Maximum count of loaded preview images enter a smaller value. A preview image can take up to 120 KB of memory.
Upon reopening a database, calculations already performed are repeated.
You can ensure that FlexPro stores all calculated results in the project database. These then do not have to be recalculated in the next session.
1.Click File > Info > Project Database Properties.
2.Click on the General tab.
3.Select the options Save calculated images of presentation objects in the project database and Save calculated results of formulas in the project database.
Note: FPScript formulas that provide a vague result, such as functions containing a user prompt or use the Noise function, are recalculated at each update and are not stored in the database.
The project database requires a considerable amount of hard drive space.
You can reduce the amount of hard drive space required by project databases by not saving optional elements on the hard drive.
1.Click File > Info > Project Database Properties.
2.Click on the General tab.
3.Uncheck the options Save calculated images of presentation objects in the project database and Save calculated results of formulas in the project database.