I had a side project game that made it to the front page for half a day and it logged about 28k visits for that day.
Any proven open source database should be able to handle that, sqlite included. It's most likely some form of bloat sitting in the middle slowing everything down. And probably more due to the way the page is generated via 'low code' framework vs. the intention/design of the author.
