Optimise database performance and connection management

Improves system stability and responsiveness by optimising database queries and connection handling, particularly for public course listings and high-traffic operations. Reduces page load times and prevents performance degradation during peak usage periods when multiple users are accessing the platform simultaneously.