ActiveAndroid optimization relative tables

Question

I have the app that uses ActiveAndroid ORM and I need to save list of models with inner list and objects, that looks like this:

public class MyModel extends Model{
 @Expose
 @SerializedName(Columns.COLUMN_CREATED_AT)
 @Column(name=Columns.COLUMN_CREATED_AT)
 private Date createdAt;
  .... and other fields

 @Expose
 @SerializedName(Columns.User)
 public User users;
 .... another objects
}

so, the current logic that saves List<MyModel> do next:

1) makes all update in ActiveAndroid.beginTransaction() / ActiveAndroid.endTransaction(); block

2) for each MyModel user model retrieves from db, updates and saves

3) each MyModel retrieves from db, updates and saves

so the whole process takes about 7-9 seconds.

As the user (and others inner objects) can be the same in different MyModel objects i've do the next:

in the loop that saves MyModel I gets the users and put it to HashMap, so i got the list of unique users and saves it after MyModel updates. (but the same transaction). now it saves data for 3-4 seconds.

BUT, looks ActiveAndroid makes some references between MyModel and User table, so when i tried to remove users from table i got an exception:

FOREIGN KEY constraint failed

so, how can i deal with it?

Answer 1

As ActiveAndroid is not supported for last 3 years... the solution for me was to migrate to another orm. one more reason against ActiveAndroid - is slower than others