Has anyone out there added additional Database Extents to their
Progress Vantage Database to help improve performance? I have heard
you can create multiple database files (D1, D2, D3 and/or B1, B2,
B3...) and place large tables (parttran, labordtl, etc...) in these new
database extents to help increase read/write performace on the database.
I have been doing some research on Progress's website on using the
PROSTRCT ADD command and creating a new .st file to describe the new
storage area/extent info, but before I got too into this I was hoping
someone in the group has already done this and could give me some
pointers or point me in a good direction on how to go about this.
It is my understanding that once I create the additonal data extents I
can move them to different disk drives and possibly improve the
performace of the database greatly. If anyone has any experience with
doing this or knows of someone who has I would appreciate some feedback
or some documentation that can help me out. Thank you
Robert Nupp
Vantage 8.03.403C Progress
Progress Vantage Database to help improve performance? I have heard
you can create multiple database files (D1, D2, D3 and/or B1, B2,
B3...) and place large tables (parttran, labordtl, etc...) in these new
database extents to help increase read/write performace on the database.
I have been doing some research on Progress's website on using the
PROSTRCT ADD command and creating a new .st file to describe the new
storage area/extent info, but before I got too into this I was hoping
someone in the group has already done this and could give me some
pointers or point me in a good direction on how to go about this.
It is my understanding that once I create the additonal data extents I
can move them to different disk drives and possibly improve the
performace of the database greatly. If anyone has any experience with
doing this or knows of someone who has I would appreciate some feedback
or some documentation that can help me out. Thank you
Robert Nupp
Vantage 8.03.403C Progress