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

  • Thread starter Thread starter Gareth Vincent
  • Start date Start date
Status
Not open for further replies.
G

Gareth Vincent

Guest
Hi Steven, the rule of thumb is to separate all high processing tables into their own storage areas along with its own index area. The RPB will vary per table so make sure you allocate tables accordingly. I usually stick to either a cluster size of 512 for large tables and 8 for everything else. For all other tables I would group them based on their RPB and cluster size.

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