Searching "Touhou" in combination with "Fate_(series)" times out database

While searching for posts tagged with both "Touhou" and "Fate_(series)", a database timeout error will occur either on the first page or the second, and on any pages after. Both individual tags are uneffected, however, as is any other search.

Details of the error:
ActiveRecord::QueryCanceled exception raised
app/logical/pagination_extension.rb:73:in `records'
app/logical/post_sets/post.rb:138:in `posts'
app/controllers/posts_controller.rb:14:in `index'

It's because both tags are huge but only produce a couple hundred results together, adding in a order:score should make work.

Since basic users are limited to two-tag searches, there’s no way to make it work for you. You have to either add order:score, as Unbreakable suggested, which will make it harder to find newer posts, or something like age:0d..30d, then age:30d..60d, etc. Both variants are three-tag searches that require a Gold account or above.

Upgrading your account also increases the length of time it takes you to time out the database, so you'll experience fewer timeouts even without adding extra tags to your searches.

You can use "limit:" to reduce the number of page displayed on each page. Unlogged, I can search up to "touhou fate_(series) limit:50" without timeout. "limit:" can be used in addition to two other tags even without gold account.

KevinBrandon said:

After finally taking down the sister of Scarlet I'm ready to start tackling the EX Stages of PCB. I was just wondering if there's any, with no better way to put it, "tips and tricks" for both Extra and Phantasm. I've already poked at Ran a few times so I'm at least vaguely familiar with the former (but haven't gotten very far yet). I've also watched a couple of clear videos and all that. I'm just wondering if there's any general knowledge things I should know for these stages, like how to manage getting lots of blue points while also not dying. Have a fantastic day and all that!

The Danbooru forums are strictly only about Danbooru. You will need to ask somewherelse. The Reddit's Discord server now acts as general western hub i believe, so you could look into that.