a demo of the search engine running locally. Yes, it is that fast. And its not just counts, but the actual result sets. (in this case, no fetching is done though)

Also supports and/or, even nested, along with ranking by whether it has a specific search term (called boosting in the documentation) Oh, and in the example, the default blacklist was used. https://derpibooru.org/pages/search_syntax