jeffschaper commented on issue #8260: URL: https://github.com/apache/incubator-devlake/issues/8260#issuecomment-2624846222
@kgalli - Thanks for the reply! Indexing does seem like low-hanging fruit to improve performance. My colleague and I analyzed the explain plan for a few of the queries and rewrote a couple of the common table expressions (CTE). We noticed the queries ran much faster (minutes to seconds) after making those optimizations. We're hoping to contribute that back to the project, but we're still validating the diff (since the SQL statements are embedded in the Grafana JSON, it's a little tricky to make sure the changes are being applied correctly). Appreciate your reply! Thanks for offering support! -- 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: dev-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
