Tool
Searches (Optimization checklist)
Bubble · manual.bubble.io Free Intermediate
This is Bubble's reference page on how searches actually execute, and it is the highest-leverage read for your problem because it explains that Bubble indexes your data automatically once the volume is large enough, and that privacy rules keep unmatched data from ever leaving the server. Understanding both means you can set your database up so the engine does the filtering for you instead of shipping thousands of rows to the browser first. Keep it open as a checklist while you audit each slow search in your app.
- Bubble adds database indexes automatically for common query patterns once your dataset is big enough, and it does not cost extra workload, so structuring searches around real constraints lets that indexing kick in.
- Privacy rules are not just security: fields a user cannot access never leave the server, which cuts the data returned to the browser and the workload that comes with it.
- Text matching only indexes the first 256 characters, so very long text fields are a poor thing to search on when speed matters.