Commission Rate Page Taking Too Long to Load

Describe the bug
The Commission Rate page in the admin panel is experiencing excessively long loading times. When accessed, the page either takes several minutes to load or doesn't load at all, leaving the interface stuck on a loading spinner or blank state.

To Reproduce
Steps to reproduce the behavior:

Log in to the admin panel

Navigate to the Commission Rate page

Observe that the page takes a long time to load or never fully loads

Expected behavior
The page should load within a few seconds and display the list of vendors or commission settings without delay.

Screenshots

Image

Desktop (please complete the following information):

OS: Windows 11

Browser: Chrome

Additional context
This issue affects admin productivity, especially when adjusting commission settings for vendors. It may be caused by inefficient database queries, unhandled exceptions, or excessive data loading without pagination.

Start by reproducing the issue in the admin panel: log in, open the Commission Rate page, and observe the spinner or blank state. Trace the page's vendor or commission-settings loading path and check whether excessive data loading, inefficient database queries, or an unhandled exception is involved. Done means the page displays the settings within a few seconds.

Written by the indexing model from the issue text.