cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Import of Registry keys (2021 R1 and above) might result in poor Import performance

mfranz
By Level 17 Champion
Level 17 Champion

Hi,

A customer (less than 5k devices) noticed nearly 12 hour inventory import & license reconcile after migration from 2020 R2 to 2021 R1. They do collect quite some registry keys (about 3.5 million rows) and while the Reader is quick on these, the Writer struggles with the wildcard import. I did some manual testing:

  • 1 row took 3 seconds
  • 10 rows took 1 minute 23 seconds
  • 100 rows took 20 minutes 23 seconds

Not sure which impact DB server sizing had here, but obviously LIKE-comparisons on 3-4 attributes on a large data set are expensive operations. I don't really see how this can be improved easily.

We're going to change the reader to prevent it from importing all Registry keys from the Inventory DB, basically restoring 2020 R2 functionality.

I guess, as more customers move to 2021 R1 and beyond, they might encounter this, so this is just to raise awareness.

Best regards,

Markward

Edit: The title mentioned "Reconcile performance", which is technically not correct, writer inventory import will suffer.

(0) Replies