If you check out Robert Petitto’s awesome video (🧲 The QUERY Column: One Column to Rule Them All!) he mentions that when this happens you should use a relation to get the data you need, then use the query to filter the results. This should be faster than just using a query, if I understood him correctly
Hmm, are two calculated columns faster than one of them? Bearing in mind that Relation+Query is faster than Query with two conditions?
At what scale is the difference noticeable?
On the amount of data in which the search is performed? Thousands, tens of thousands or hundreds of thousands?