Forum Post: Re: Performance Degradation After Dump&load

  • Thread starter Thread starter Piotr Ryszkiewicz
  • Start date Start date
Status
Not open for further replies.
P

Piotr Ryszkiewicz

Guest
Hello Rich, Thanks for suggestion, I will increase Toss limit to 400 together with Create limit. Regerding most frequently used index - you are right it's not the primary index. But changing dump&load order would help performance only for a while, as new records would anyway be created in primary index order, and queries are most often run on newest, not old data. I am also going to create separate area for each of frequently used indices. But still - it does not answer my questions. Why these holes are there after the load ? Regards, Piotr

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