How long should it take to retrieve a record from the db, with one single search criteria?

Need help Database
1

I’m finding Bubble amazing! But one thing that is worrying me is the latency is quite long to retrieve a single search record.

I have a data type called Hashtags, which is fairly simple. Besides the default unique_id attribute, it has a name field and a counter.

Whenever a user adds a hashtag, I want to verify that a hashtag object with that name does not already exist.

For some reason, this can take several seconds - why?

I tested creating a hashtag (add) without the search and it was almost instantaneous.

Can anyone advise? I’m guessing Bubble’s db are indexed? I heard that indexed database tables are very fast for searching as described above.

I’m not doing any complicated table joins, just looking for a single record in a very small list of records of a particular type…

Thanks!

2

Assuming you’re putting the create conditional inside the wf with other steps that are conditional on it not finding anything in the search, it may take a long time. Especially if each conditional relies on a search.

Displaying UI elements on search is quite a bit faster, so what you could do is have two UI elements both hidden and one shows on search and the other is visible when the first one isn’t. Might be faster, but that’s me guessing. Screens of your calls will help us diagnose the issue much more easily and help if we can.