Sometimes sqlite really is shit

I have a lot of repos in my private gitea server because I mirror repos I care about accessing locally

well, it's come to the point where loading my dashboard after login takes somewhere between 4-8 seconds to render the page... the template it says renders in a dozen or so milliseconds

so I enabled all the redis caching options.

It got better. 1.5 - 2 seconds now.

I just migrated the gitea database to my postgresql server

Now it loads in 25ms

Like holy shit batman, that's a world of difference