Btw, here is an interesting quote from Petter (author of “The Ultimate Guide to Bubble Performance” book):
Thanks for posting! The difference that you bring up about :filters being performed server-side/client-side was one of the major revisions of the second edition of the book, and if that’s the version you’re referring to it may not be clear enough still (I can’t check the book right now, but thanks for including page numbers).
In the first edition, filters were described as being performed client-side more or less without exception, but it should have been made clear that this will normally only apply to advanced filters (or filters applied to an already completed search). Whenever a :filter is applied to a fresh search Bubble will attempt to perform the full query on the server and in many (probably most) cases it can.
[source]
So it would be great if @petter could confirm if it’s still a thing.