Forum Academy Marketplace Showcase Pricing Features

Move complex search to backend

Hi there,
is there a best practice for moving complex searches from the client to the server? Currently I have a search with a slow filter / advanced search on the client side. I want to match database entries from the current user to other users entries in the same table. E.g. I have a entry for every hobby of the user. Currently I do search for the current user and its hobbies and intersect them with other users. I hope it is a little bit clear what I want :slight_smile:
I’ve tried to start a API Workflow, but I was unable to show the result in a repeating group.
Thank you for your hints.

When a page triggers an API Workflow is a one-way thing. It tells the backend to do something. You can’t add a next step and refer to it like Step 1's Search result for instance.

On the other hand, you could probably:

  1. trigger an API workflow.
  2. make the page watch some data’s field for a change.
  3. do something when the data changes.

That something could be to display a list created by that API Workflow.

Another idea is that you try to do your search natively. I would refactor my data structure following @petter 's recommendations: The Ultimate Guide to Bubble Performance - the new edition is out (now 210 pages!).


Hey Rico, thx for your reply. I understand :slight_smile:

If you don’t find a good/workable solution within bubbles ecosystem, using a custom built cloud environment could solve this issue for you and be lightning fast.

If that piques your interest, let’s chat!

Learn more

Need to have your database located in your region! Tired of struggling with Bubble or API’s? Need a little functionality that’s not available yet thru current market plugins? Experience your own bootcamp!

Are you ready to step-it-up or speed it along? Need some custom code or a plugin built? Contact me today to learn how to book a 1-on-1 session, get your plugin built, or yet freelance building support!

Office Hours:
Mon - Fri
9:00 AM - 5:00 PM

Send me a message today:
[email protected]

This same question has bedeviled me and I haven’t yet found an answer via the forums. The list-to-list search (which needs an advanced filter and the intersect with function) is executed client side, so it’s not scalable.

In terms of moving it server side, I’m aware of 2 methods:

  1. Have the search execute via an API workflow (you can build the same advanced filter in there), and then have Bubble trigger the search and receive the results via the API connector, as though it was pulling data from an external source.

  2. Use an intersecting table and search based on that (this is more the standard database approach).

This is on my dev list to-dos and I am going down the road of #2 to see how it performs. I will post the outcome.

1 Like