Search Results
6/3/2025, 4:50:47 PM
>>42243033
I realize I'm probably pushing what should be done with SQLite, but I don't feel like it's too far off. This is a booru search and as long as the query times are somewhat in line with existing boorus I'd be pretty happy. And as it stands query times are basically there for searches that aren't this worst case scenario. And even for this particular query with a huge amount of results, the time of the query without COUNT OVER isn't too much slower at just under 1 second. Comparing to Twibooru (hardly a fair comparison since other people use the site and I don't know what sort of hardware they run), a similar search there takes around 850ms.
Anyway, here's a comparison of the query plans. I guess there's a bigger difference between them than I initially thought.
I realize I'm probably pushing what should be done with SQLite, but I don't feel like it's too far off. This is a booru search and as long as the query times are somewhat in line with existing boorus I'd be pretty happy. And as it stands query times are basically there for searches that aren't this worst case scenario. And even for this particular query with a huge amount of results, the time of the query without COUNT OVER isn't too much slower at just under 1 second. Comparing to Twibooru (hardly a fair comparison since other people use the site and I don't know what sort of hardware they run), a similar search there takes around 850ms.
Anyway, here's a comparison of the query plans. I guess there's a bigger difference between them than I initially thought.
Page 1