chess-pipeline icon indicating copy to clipboard operation
chess-pipeline copied to clipboard

Published 20 hours ago • verified publisher icon guidopetri

Queries are slow

Open guidopetri opened this issue 4 years ago • 0 comments

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.

guidopetri avatar Feb 24 '21 02:02 guidopetri