Very great job! Sometimes, I have to offload some tables to my custom BE due slow q, and index them myself, plus adding views. I already see improvements tho.
2 Likes
@tj-bubble Did you update the search costs as well? I’m seeing a 20% spike in search costs since my people started working Monday.
I don’t think so.. they would have at least mentioned it.. How do you say that?
1 Like
False alarm. Thanks to the billing model we now allocate time in our daily standups to look at usage. It suddenly jumped by 20% since Monday. However, I just got confirmation from Business this is due to a reshuffle in reporting lines that kicked in this Monday. Guess we now need to issue an instruction to business that they need to confirm WU capacity before doing management changes. I can only imagine how that’s going to go down when the tail tries to wag the dog…
1 Like
I also noticed a spike in search costs even though the app usage was normal. I haven’t analyzed it in depth yet, but I think I should now.
2 Likes
In my case it’s always constant.. I haven’t noticed an increase in WU.. Let’s try to hear from them for an official confirmation.. @fede.bubble
2 Likes
Any plans of giving us Joining features for queries?
2 Likes
Thank you for the update @tj-bubble .
If I’m understanding correctly, these optimizations affect the end users of our apps (which is always top priority to be clear).
Will we (as the developers) notice performance differences when we’re doing backend work in the data tab?
1 Like
Actually yes! Part of the improvement helps the wildcard search in the data tab as well, which uses the same underlying mechanism as “Any field contains” search.
Regarding WU increase, there should be no change at all to WU for this change, the index creation doesn’t bill WU. The only thing I could think of that might be related to this would be if you previously had a query that was timing out that stopped work from completing, and now it works, which would mean your app is doing the work it should be doing.
5 Likes
@tj-bubble great update, this makes building data intense apps easier!
If Bubble would also have cheaper WU and hosting in EU without an enterprise then that would make it perfect 
2 Likes
Anybody can confirm you can see direct impact of performance improvement? I just see drops of around 10 - 30K WU daily but that can be also connected to some of my improvements. Nothing apart from that. I will be also asking my users to check it. For me the biggest block for bubble were the nested searches and the limitation of search vs advanced logic - where I couldn’t perform some of the operations on the fronted. (most common issue was with finding overlaps against some related databases of 2 sets of data).
1 Like
This is great news 
Question: Does this speed up operations such as modified / created / deleted Thing backend events? It seems like if the DB search is faster, those events trigger faster as well, correct?
Thank you 
1 Like
Sounds Awesome!
1 Like
very cool - thank you
1 Like
Farouk, we identified a specific report using start and end dates. I suspect some of the WU could be because the date changes now manage to execute completely on the RG every time a change occurs whereas previously it may have not completed and perhaps not charged. Just a theory not fact. Anyways, we’re still trying to figure out how we’re going to deal with this. Looks like we may have to convert to old school style reporting with “Run” buttons.
1 Like
Great update @tj-bubble - These are the types of improvements that will keep Bubble competitive against the vibe coding tools. Thank you. 
2 Likes
Hi, I’ve got a question
When using Bulk operations in Bubble, I want to update the number field of multiple rows so that the records are numbered sequentially.
The logic is: for each record, find the maximum value of number in the list and set it to max + 1.
Problem: All records in the list end up with the same value.
Expected result: For example, if I have 14 records with number = 1, and the maximum existing value of number is 52, I expect the list to become 53, 54, 55 …
Actual result: All records receive the same value (e.g., 53).
1 Like
Is this real? When I delete a thing all references are removed? That doesn’t appear to be the case before this, as far as I know.
1 Like
If I delete a a Company, and I have some Invoices which have a Company field, then the Company field on those invoices will become empty. It won’t delete the Invoices.
You are having issues with WU usage for reporting data?
1 Like