Millions of rows can bubble search features work on that size of a dataset?

Need help Database
4

Hey @court,

It should work okay without using the Algolia.

I had the same question before, so I decided to test it.

  1. There are 1 868 420 of records:

    image
    image1439×757 59.5 KB

  2. The following preview page shows the total and the first four records immediately:
    https://jus4tests.bubbleapps.io/version-test/urls

image

Note: The app is on the free plan.

The most important thing is to structure the database in the right way.

For instance, for a Product table you need to create an additional one Product Details that will have such fields as a full description, list of images, etc.

The idea is to have a light table to avoid issues with its slow preloading/loading.

You need to be ready for the following things to do in the case if you want to use the Algolia:

  • Custom pagination
  • More workflows for displaying data because you need to run it within a workflow’s action
  • Handle things on the Algolia side
  • Additional privacy configuration
11 Likes