[Progress Communities] [Progress OpenEdge ABL] Forum Post: DB-conversion to SAII - Advice on tables that have a lot of creates and deletes

  • Thread starter Thread starter Steven Peeters
  • Start date Start date
Status
Not open for further replies.
S

Steven Peeters

Guest
We will soon be converting our "all-in-schema-area" Type I SA database to a Type II SA with the tables and indexes grouped per RPB-value (as calculated using the DBAnalys). Most tables in this DB are fairly ordinary except for 2 tables that we use to for our custom-made CDC system. These tables will have a lot of creates and deletes in a short amount of time, offloading the records to an external DB. Now that we're in the process of examining the conversion, I was wondering whether or not I should place these tables in a seperate area, assign a specific RPB or cluster value? Regards, Steven

Continue reading...
 
Status
Not open for further replies.
Back
Top