DBFlow - update multiple items efficiently

Question

ArrayList list =... --> Get data from database

//do some changes in the values of the objects in the list

for(MyObject object:list){ object.save(); }

Instead of this for loop is there a way to save multiple items that is more efficient than calling save() a bunch of times?

score 2 · Accepted Answer · answered Jul 27 '17 at 10:14

Finaly found it

FlowManager.getModelAdapter(MyTable.class).saveAll(myObjectsList);

and it's faster than calling save multiple times. From some quick testing for 15 items the multiple save took an average of 120 milliseconds while saveAll took about 100 milliseconds. percentage wise it's quite a big difference.

score 0 · Answer 2 · answered Jul 27 '17 at 09:40

0

Calling save() multiple times is ok. If there is a thousand entries, you can do it with asynchronous transaction to avoid blocking UI.

If you really want to do save one time, create a new table(model) name ListObject, then use the relationship one-to-many to store it as a List<Object>. So have to save one time only. https://agrosner.gitbooks.io/dbflow/content/Relationships.html

answered Jul 27 '17 at 09:40

phatnhse

3,870
2
20
29

there is a way after all..thnx for pointing me to the documentation i hadn't found that before. i posted the answer below – Anonymous Jul 27 '17 at 10:15
yah, glad you found the answer – phatnhse Jul 27 '17 at 10:17

DBFlow - update multiple items efficiently

2 Answers2