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 Commission Rate page loading issue in the admin panel and trace the page's data-loading entry point and network requests. Check whether the vendor or commission-settings list is blocked by excessive data, slow queries, or an exception; done means the page loads within a few seconds and displays the list reliably.

Written by the indexing model from the issue text.