Hi paolo,
just playing around with some thoughts. Please comment on this if you have time.
So, first when searching via distance, the query’s most important parameter is the distance, and it is sorting out the results in an array with the closest listing first, etc., etc. Then this array is displayed as the search results. If we need to put the condition featured too then we have to create this second query to re-filter and rearrange the results and slowing down the performance. Am I following correct here?
What if when searching by distance we save the results in 2 arrays with a condition like this:
if distance + featured => save in array 1
if distance + non-featured => save in array 2
Display first results array 1, then display results array 2
Is this possible? If yes, would that skip the second query or harm the performance?
Curious about your comments. Thanks.