[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Changing data area structure on a 3rd party Progress App

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
This will not affect CRC, so you won't need a recompile (although testing is still a very good idea!) You can get all fancy with the distributions, and you may get some benefits, but a 62GB database isn't that big. You will get most benefit from splitting tables, indexes and LOBs into separate areas. If you do want to do some separation, then split off your busiest tables into one area, put the indexes for those tables into another area, and then stick your remaining tables into an area with the indexes again separate.

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