How long is a "Do a search for" on a large dataset?

Need help Database
1

Hi Everyone,

I am trying to understand how fast a “do a search for” would be on data type that has 50’000 entries. In my example, I have a data type called “Available range” with 5 fields :

  1. date range
  2. start date and time
  3. end date and time
  4. yes/no field
  5. text field with 36 caracters

My do a search for would return on average only 20-30 entries in a repeating group. Here is my setup :

Capture d’écran 2024-05-07 à 17.25.32
Capture d’écran 2024-05-07 à 17.25.321458×870 105 KB

From the moment the do a search for is triggered, how long will it take to successfully display all the results (about 30) in my repeating group ?

Thank you for your help

2

Depends on the Users devices’ computing power and internet speed connection.

1 Like
3

Let’s say an iPhone 14, and 50mb/s download speed, would you have any estimate ?

4

Less than 3 seconds