Kbase P106007: Best Practices involving the Schema Area.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2008 |
|
Status: Verified
GOAL:
Best Practices involving the Schema Area.
GOAL:
Why it is important to move the data out of the schema area in Progress 9.x ?
GOAL:
Why it is important to move the data out of the schema area in Progress 10.x ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
There is no technical reason why more than schema information can not be placed in the schema area and there is no requirement that prevents data from being placed in the schema area. Anyone who is converting a database which was created prior to Version 9 should not be focused on this single issue unless they have requirements to take full advantage of storage areas. The following features may not be taken advantage of if data is left in the schema area.
1. Cannot adjust the number of records per block in the schema area to use the data space more efficiently.
2. Some management operations cannot be done on the schema area.
A good example of this is area truncation. This operation can only be done on user data areas, it does not work on the schema area.
3. The power of storage areas comes from addressing physical disk to a particular Storage Area. This allows one to target very specific I/O paths to an area. When the mount points are different physical devices, either striped sets or single disk drives, one can guarantee that writes that affect both an index entry and a table entry will happen in parallel, which is an aggregate cost of only a single I/O.
4. Storage areas provide significant increases in physical database size limits. The two most common requests for increased limits have to do with sizes of individual tables and numbers of records per block. Having mulitiple areas and tunning the records per block will allow for the largest possible table size for the data being stored. This was not possible until storage areas were introduce in version 9.
These same limits apply to the 64 bit versions of Progress.