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

[mfranz]

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.