[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 cjbrandt
  • Start date Start date
Status
Not open for further replies.
C

cjbrandt

Guest
Start your table area number higher - like at 100, so the AI extents can use the area numbers 7 - whatever. Then the AI extents aren't scattered through the structure file. Make table area numbers even and the index area numbers odd. It helps when you area scanning through the db log and see a data error, you know if it impacts an area with table data or just an index. Make a list of gifts you will accept, because moving tables from schema area to separate SAII is going to make you very popular in your company.

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