My app has recently started getting loads of Workflow error - Database query timeout responses that cause a workflow to fail. Can someone tell me how to fix this specific example? The table in question currently has about 600k entries. I just want it to fetch any single entry that matches a single …

@alan8 It’s possible you’re about to explain something to me about how Bubble queries work that will make my searches way more efficient. :crossed_fingers: Here’s what I’m doing along with my understanding of why: My Posts table has a field called Team which is of type Team - in other words, a …

@code-escapee Thanks for your input. If you are looping thru how are you making sure not to select the same post on the next run? Also what’s happening in the next step? Is there a timeout on the first run ever or only when subsequent steps from previous runs are still in progress? Simply by s…

@ahmed.elkaffas If this is your main task, then I would suggest using Triggers on the related tables to delete whatever related Post entries without doing any searches. I don’t understand your suggestion. What would trigger the trigger? This is a manual task I currently trigger when necessary f…

[image] david.j.hansford: I think this means that as soon as the database finds a single entry that matches that criteria (and for context, there are currently 1.4k) it should return just that entry and use it. Unless I’m mistaken, that appears to be the simplest way to find any single entry tha…

Here’s a separate (but related) question: What’s the most efficient way of asking the database if there are any more entries that match my criteria in a table? I used to do Do a search for X :count >0 However I assume that isn’t very efficient. As a result I am currently trying: Do a search for …

[image] david.j.hansford: What’s the most efficient way of asking the database if there are any more entries that match my criteria in a table? @adamhholmes answered this: [image] Search: count is 0? Or Search:first item is empty? Tips So, since the change in prici…

@georgecollier No images are saved to the Posts table. All non-text is saved elsewhere, with a link created through a Posts_attachments table. The message can be very long, but it will only be normal characters. For context, these are slack messages that we are saving. Add some more constraints a…

Well my concern is the search that includes the items until #1 as well as first item seems to be effectively two queries of the same thing. Which seems inefficient. And clearly there is an issue here where the volume of data being returned is causing the hard limit to kick in.

[image] david.j.hansford: Is saving Team of type Team against every entry in the Posts table not essentially saving the Team’s unique ID? Yes, this is correct. In Bubble’s backend, it’s just a string that’s the unique ID of the thing. [image] david.j.hansford: The entire workflow is just…

@georgecollier @adamhholmes answered this: Thank you for this! Just read his post, will read the rest of the thread when I have time. Understanding how to maximise WU, database load and server load as becoming top priority for me as my app is pushing against the limits more and more as it grows

Database Query Timeout - please help me fix my database query

Need help Database

georgecollier May 30, 2024, 10:40am 13

@adamhholmes answered this:

Topic		Replies	Views
Optimal Database Design - Advice? Database	23	2071	April 3, 2024
Any ideas on speeding up read/write to database? Database	23	4093	November 15, 2016
Query item from #50001 issue Database	25	257	August 6, 2025
$650 Workload Overages Need help	57	952	March 24, 2025
Speed is an issue Responsiveness	64	11330	December 12, 2017

Database Query Timeout - please help me fix my database query

Related topics