laravel optimization challenges

we're still battling some deep-seated performance issues after initial troubleshooting. specifically, our custom reporting module, despite extensive query refactoring and proper indexing, is hitting a wall. even with horizon and queues, the underlying data aggregation for larger datasets remains slow, impacting our laravel optimization efforts significantly.

what advanced strategies or tools have folks used beyond standard eloquent/db optimizations for complex, heavy data processing in laravel? anyone faced this before?