Pre-render utilization data for aggregates, prefixes, and IP ranges

[jeremystretch]

NetBox version

v3.0.5

Feature type

Change to existing functionality

Proposed functionality

This issue seeks to explore the feasibility of pre-rendering and recording utilization data for aggregates, prefixes, and IP ranges in the database. Currently, when retrieving a list of prefixes, NetBox will calculate the utilization of each on-demand. As an alternative implementation, we could store these values directly on each object in the database, and update them appropriately as child objects are created and deleted.

Use case

This would greatly improve performance where utilization data is required. It would also enable us to easily return this information via the REST API as proposed in #7292.

Database changes

Addition of a utilization decimal field on each of the affected models

External dependencies

No response

[jeremystretch]

Ditching this idea in favor of #7845.