adiranjan25 commented on issue #76959: URL: https://github.com/apache/airflow/issues/76959#issuecomment-6814529066
Hi @seanghaeli, I'd be interested in working on this issue. The scalability problem with large SQL `IN` parameter lists is closely aligned with my background in database query optimization, distributed data platforms, and performance engineering. I'd like to investigate a solution that eliminates the DAG-count-dependent bind parameters while preserving authorization semantics, accurate totals, stable pagination, and existing sorting behavior. My proposed validation would include regression tests for task, callback, and asset-watcher triggers; restricted user visibility; and performance testing against larger synthetic DAG populations. Before implementation, I'll review the current route and authorization logic to ensure the approach remains compatible with existing Airflow behavior. Please let me know if there are any additional constraints or an implementation already underway. Thanks! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
