Optimize controllers for large datasets

**Problem**
When working with middleware, the error messages could be more descriptive.

**Suggestion**
Improve error handling and add detailed error messages.

**Context**
This would help with debugging and maintenance.

Start by locating the controllers and middleware involved in the issue, then trace how errors are currently handled and reported. The request is complete when error messages provide more detail and the resulting behavior is verified for the relevant middleware paths.

Written by the indexing model from the issue text.