Forum Post: Re: Performance Degradation After Dump&load

  • Thread starter Thread starter Abri Venter
  • Start date Start date
Status
Not open for further replies.
A

Abri Venter

Guest
Piotr, Do you grow the empty DB to size before the load ? Do you set any of the toss limits (must be higher than create limit), you did mention the create limit ? Have you compacted indexes before or after D&L? proutil dbname –C idxcompact table.index target% From Progress 10.1 onwards progress also "defrags" automatically. Thank you A Venter

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