🔗 How to optimize slow aggregate queries on +1M row tables in Ash Framework

As your application transactions grow, you will reach a point where some of the Ash components, like aggregates or filters, become slow with larger tables. When working with 1 million or more rows, aggregating queries should be optimised for better performance. In this article, we'll explore techniques that can help improve the speed of these slow aggregate queries, ensuring that your application remains responsive and efficient as your database expands.