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

Closed
opened 2025-12-29 19:28:28 +01:00 by adam · 1 comment
Owner

Originally created by @jeremystretch on GitHub (Oct 5, 2021).

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

Originally created by @jeremystretch on GitHub (Oct 5, 2021). ### 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_
adam added the type: feature label 2025-12-29 19:28:28 +01:00
adam closed this issue 2025-12-29 19:28:28 +01:00
Author
Owner

@jeremystretch commented on GitHub (Dec 8, 2021):

Ditching this idea in favor of #7845.

@jeremystretch commented on GitHub (Dec 8, 2021): Ditching this idea in favor of #7845.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#5475