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
George, > Does it mean that you can create the records that imitate the production? It's not 100% exact, but similar enough I think. I dump 5 days of real data. Then I run few parallel processes, which read dumped data into temp-table, change values of fields which are the part of primary index and copy them to the table - but not in one piece, but with several assigns. During that another process is doing random reads just to be closer to real life. > You can run chanalys. It will give our the detailed information about all 2,716,479 blocks on RM chain. I have a program that loads the "LIST OF RM CHAIN BLOCKS" from chanalys, sorts the blocks by "free space". So we can see how many blocks will stay on RM chain if the toss limit will be increased to any value of "free space". Based on chanalys' that I got from our customers the rule of thumb is: toss limit = mean rec size + 20%. Just started chanalys, it will take some time I suppose. Will you be so kind and share this program ? Regards, Piotr

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