Several queries that use the tables (mainly chess_games, of course) are extremely slow - they take about 4-6 seconds to run. This can probably be improved via usage of indices, but I'm not sure whether placing the indices is worth it, since it would cost a lot computationally when running the pipeline each night.
I would like to investigate this to improve query runtimes.
Several queries that use the tables (mainly
chess_games, of course) are extremely slow - they take about 4-6 seconds to run. This can probably be improved via usage of indices, but I'm not sure whether placing the indices is worth it, since it would cost a lot computationally when running the pipeline each night.I would like to investigate this to improve query runtimes.