Kbase 18168: What are Storage Areas?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/08/1998 |
|
What are Storage Areas?
INTRODUCTION:
=============
This knowledgebase article explains what storage areas are and why
Progress has implemented them in Version 9.
WHY YOU NEED TO KNOW THIS:
===========================
This is to help address some limitations in previous Progress Versions
and to assist in improving database maintenance times.
Progress introduced storage areas in version 9. In version 8 there
were some limitations to the number and size of extents that a
Progress database could have. The maximum number of extents was 256
and the maximum database size (for an 8k database) was 256 gig.
Another reason Progress introduced storage areas was to increase the
performance of utilities such as index rebuild. In version 8 you had
to read the complete database to rebuild 1 index, no matter how large
the index was. With the advent of storage areas you only have to read
the storage area that the table and index are in. This speeds up the
process greatly.
The current limit to the number of storage areas you can have in a
database is 1000. You can have 256 extents in each storage area.
Each extent has a maximum size of 2 gigabytes.
You can place 1 or more database objects in a storage area. Objects
consist of tables and indexes. These can be mixed in any form.
This allows you to control which objects run on which devices giving
you more flexibility to tune your application and database.
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Progress Version 9 Product Update Bulletin Chapter 3