I am creating a list of things which will contain 100+ items in it and saving them in a another database which contains all new created items in my bubble.io app. Currently I am using backend workflow for creating and saving them in other database but it is taking more than 2 minutes to created those 100+ items and saving them in database. How can I overcome with it?
Please Help @adamhholmes @mikeloc
Thank you in advance.
Bulk operations in database is a pain in the *as in Bubble. It takes more time than it should. It is what it is……
But this is not a good experience @rpetribu , we need to find out solution for this.
I think they have announced something regarding bulk operations in database in BubbleCon! It is a known issue…
Recently 
…
If you search you will find a lot of similar posts here in the forum….
Yeah… as @rpetribu says, Bubble have announce d major improvements to bulk data operations for next year…
So you can either wait until then…
Or use the Data API Bulk Create Endpoint… it will take seconds (or less) to create 100 things.
What’s your use-case and why is it critical from the user perspective that those records should be loaded very quicky?
I tried Data API Bulk but I don’t know how I will add that list to other DB.
You got Bulk Create working, but you just need to refer to the newly creating things in the next actions? In the Bulk Create API call you specify the datatype in the URL, so it knows which datatype you want to create Things for.
If you have 100+ items going into a list field, me and @adamhholmes probably don’t recommend doing that, but it can be done.
Hey @jangidrahul0494 
What I have done in the past was to create a list of however many items I need first. If there are a 100, then I create 100 template items in the database. Copying a list of things is much faster than creating one thing at a time. Then copy your list of templates and make any changes you need to them after that.
You can also do this using the API Connector, but you might not need to go that route.
Does that make sense? Does that help at all?
What I am doing in my app is that user can create a calculation. And a calculation will have list of items with there all attributes. Now when a user click create calculation button , we need to create new items for that calculation and add them to the calculation. And we are creating these item through backend workflow which should create these items were quickly but right now it is very slow.
"What I am doing in my app is that user can create a calculation. And a calculation will have list of items with there all attributes. Now when a user click create calculation button , we need to create new items for that calculation and add them to the calculation. And we are creating these item through backend workflow which should create these items were quickly but right now it is very slow."
@tylerboodman @adamhholmes Can you please provide a better solution for this?
This topic was automatically closed after 70 days. New replies are no longer allowed.
