kgalli commented on issue #8260: URL: https://github.com/apache/incubator-devlake/issues/8260#issuecomment-2621138385
I noticed that there is a lot of room to improve query performance by adding some indexes. You can easily login to the instance and enable slow query logging. I added a couple indexes myself to also improve the time spent on running the DORA calculations (from several hours down to minutes. I'm running 1.0.0 and will update to latest soonish. Once done I will check the performance again and if needed create a PR to suggest the indexes I added. In 1.0.0 I saw that a lot of foreign keys were simply missing e.g. for all those pull_requests_XXX tables which have the pull_request_id foreign key. -- 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
