...
| Excel | ||
|---|---|---|
|
De-Registration: Test Measurements
...
With and
...
Without Orphanage removal
During de-registration the system remove ‘orphaned’ yang resources ie modules that are not in use any more after each batch using an expensive query.
Instrumentation showed a very high percentage of time was spent in this method when >20K cm handles were added to the system. This is because of the exponential growth of the relations between modules (schema sets) and yang resources.
The idea of this experiment/PoC is to no longer do this deletion during de-registration for each bath but do it on a much less frequent basis e.g. system start-up. In practice a module will rarely become orphanaged and even if it does there is no harm for that data to be present in the DB until the next restart of the system.
To see the impact of this change I simply removed the relevant call in the de-registration algorithm (during schema set deletion). The effect is very small (within the margin of error) for the original test sample size of 500. SO I temporally increased the sample size to 20,000 cm handles and record the following data:
Before | After (without orphan removal) | Notes (improvements) | ||
|---|---|---|---|---|
Milliseconds | CM Handles/Sec | Milliseconds | CM Handles/Sec | |
144,720 | 138 | 54,225 | 369 | |
151,189 | 132 | 57,061 | 351 | |
141,082 | 142 | 53,981 | 371 | |
Average | 137 | Average | 363 | > 2.6 x faster! |