When searching to make sure if an item already exists, is it faster to do the search and check to see if the count is 0, or is it faster to get the “first item” and see if that item is empty?

[image] brenton.strine: Keith provides the definitive answer over here: Is “first item is not empty” faster than “count > 0”? - #11 by keith :count is faster but much more expensive :slight_smile: [image] Search: count is 0? Or Search:first item is empty? Tips So,…

My guess is they’re the same but I would just create two text elements on the screen, one has count = 0 and one has first item and see which one appears first

Check this topic , first item seems to be the way to go. This is the Keith’s motivation: My experience is that such conditions ARE faster than :count. I believe that, the way Bubble works, if you have a condition that is testing for that state, that state will evaluate to true as soon as the list b…

Dangit. And I see NickC confirming that it’s a bug which they were planning on fixing 6 months ago. So this may already be fixed or could be fixed some time soon, meaning there is still not a definitive answer here.

NickG promised to look into the bug with search:count is 0 that consumes enormous amount of WUs (12.28) To avoid this you can use search:count < 1 and it will cost you just 0.2 WU And search: first item is empty will cost = 2.24 WU So search:count < 1 is 11x cheaper than search: first item is em…

Is ":count = 0" faster, or ":first item is empty"?

Need help Database

brenton.strine January 20, 2024, 8:59am 4

Keith provides the definitive answer over here: Is "first item is not empty" faster than "count > 0"? - #11 by keith

:count is faster

Topic		Replies	Views
Is "first item is not empty" faster than "count > 0"? App Organization	16	4211	April 5, 2023
Determining if List is Empty Questions	6	4134	February 7, 2019
Improvement in implementation of “:count is 0” Announcements	31	1203	September 14, 2024
When Search for... :count > 0 - is activated? Need help	2	984	December 2, 2021
Count is 0 even though I have data Database	4	1720	August 25, 2022

Is ":count = 0" faster, or ":first item is empty"?

Related topics