Filtering
In order for ParadeDB’s fast field optimizations to apply, the full text search@@@
operator must be present and used for all predicates,
including filters. For instance, the following two queries produce identical results, but the second query will return faster because only @@@
, not =
, is used.
Text Fast Fields
A known limitation of our underlying search library, Tantivy, is that text fast fields are slower to return than non-text fast fields. Future releases will improve the speeds of text fast fields. In the meantime, we recommend using a non-text field for aggregates whenever possible. For instance, usingCOUNT(*)
instead of COUNT(<text_field>)
.