Core Data Performance with Single Parent Entity

by

I worked with @deathbob on this project as the iOS lead. In our instance I had multiple classes which contained the attributes “remote_id” and “remote_update”. I initially set the tables up using subclasses. I had a “RemoteEntity” abstract entity which contained those attributes and a bunch of other entities which inherited from it, each with their own. I thought that we would end up with a bunch of tables each with remote_id, remote_update, and then their custom attributes. Instead we ended up with the massive table you describe.

The fix was pretty simple you must not set up inheritance through the GUI. Instead include all attributes for that object including your shared ones in the Core Data modeller (this means “remote_id” and “remote_update” will appear in each entity. That being said we can still use a subclass. After generating your models’ classes, create the parent entity’s class. This must not be in the GUI. It should inherit from NSManagedObject and in the .m file the properties should use @dynamic instead of @synthesize. Now that you have the parent class it is time to adjust the child classes. Set the parent class to RemoteEntity (in my example) instead of NSManagedObject. Then remove any properties that appear in your super class (in my example, “remote_id” and “remote_update”).

Here is an example of my super class https://gist.github.com/1121689.

I hope this helps, hat tip to @deathbob for pointing this out.

More Related Contents:

  1. How can I list the tables in a SQLite database file that was opened with ATTACH?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. Deleting duplicate rows from sqlite database
  4. SQLite – How do you join tables from different databases?
  5. Does SQLite3 not support foreign key constraints?
  6. SQLite – ORDER BY RAND()
  7. How to get a list of column names on Sqlite3 database?
  8. Drop all tables command
  9. Android multiple databases open
  10. sqlite select with condition on date
  11. SQLite3 UNIQUE constraint failed error
  12. Copy table structure to new table in sqlite3
  13. Update table values from another table with the same user name
  14. Transpose latest rows per user to columns
  15. Is there any boolean type in Oracle databases?
  16. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  17. SQL Between clause with strings columns
  18. Do database transactions prevent race conditions?
  19. Database EAV Pros/Cons and Alternatives
  20. sqlite alter table add MULTIPLE columns in a single statement
  21. can we list all tables in msaccess database using sql?
  22. String concatenation does not work in SQLite
  23. Comma separated values in a database field
  24. Unfindable SQLite Syntax Error
  25. Can SQL Server Express LocalDB be connected to remotely?
  26. Could not allocate CursorWindow
  27. What is the best way to implement soft deletion?
  28. Historical / auditable database
  29. Postgres: convert single row to multiple rows (unpivot)
  30. How to store a list in a db column

Leave a Comment