Databases Reference
In-Depth Information
In the
Application Properties
screen as discussed previously, you see many database
level options or properties that can be set or adjusted to suit your own computing or
performance needs. We will take a moment to briefly discuss each available tabbed
option on this screen, and the choices contained therein.
General tab
On this tab, the database name and description are displayed. Only the description
field is editable and can be changed at will. The database name can be changed
through another function not found on the properties screen (right-click on the
database name in EAS and the
Rename Database
option will be available).
There is also startup information as shown on the
Application Properties
screen.
In order to have optimal performance, leave the
Allow users to start database
checked and uncheck the
Start database when application starts
selection.
There is usually no need to have a database start when its parent application starts.
The default calculation settings are best for now. The
Aggregate missing values
and
Create blocks on equations
both have database block size implications and should
be used with extreme care. There will be much more on this topic in Chapter 5 on
database calculation scripts. We leave the
Two-Pass calculation
option checked,
because it allows you to code a member to use two-pass calculation functionality.
You are not forced to use it just because the option is checked on this screen.
It is highly recommended you set
Minimum Access Level
to
None
, as all users must
then be granted specific access to each database. The other choices are
Read, Write,
Calculate,
and
Database Designer
.
Data retrieval buffers
are settings that help with the performance of the spreadsheet
add-in, and data being extracted with a report script object. More on these will be
discussed in detail later.