Performance Upgrades for Enterprise in Kestra 1.1

Kestra 1.1 introduces significant performance upgrades aimed at enhancing enterprise-scale deployments by addressing key areas such as MySQL query efficiency and the speed of purge operations. In collaboration with Xiaomi, Kestra optimized MySQL query planning by ensuring that the deleted column is always referenced in queries, preventing full table scans and drastically improving execution times. This enhancement allows dashboards and APIs to remain responsive under heavy data loads. Additionally, the PurgeExecutions task has been overhauled to utilize bulk deletes and parallelism, reducing the time required for maintenance by approximately 2.5 times compared to previous methods. These changes enable Kestra to efficiently manage large volumes of data, ensuring that the system remains fast and reliable as usage grows, and underscore the platform's commitment to scalability and responsiveness, with community contributions playing a vital role in these advancements.