Cache the number of members assigned on each virtual chassis

[jeremystretch]

NetBox version

v3.3.1

Feature type

New functionality

Proposed functionality

Store the current count of members assigned to each VirtualChassis directly on the instance in the database.

Use case

Caching the member count improves query efficiency and solves for the challenge identified in #9329.

Database changes

Introduce a read-only _member_count field on the VirtualChassis to be updated automatically whenever members are added or removed.

External dependencies

No response

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. NetBox is governed by a small group of core maintainers which means not all opened issues may receive direct feedback. Do not attempt to circumvent this process by "bumping" the issue; doing so will result in its immediate closure and you may be barred from participating in any future discussions. Please see our contributing guide.