Hi All, I am importing a huge chunk of data from our SQL Server to our iPads for our sales reps to have archived data when they are in areas without cell service. I can bring in the data via JSON with ease. The problem I am running into is how to create the relationship between two entities efficiently as there are thousands of records.
For example, I have two entities: Order and OrderLine
- Order has a one-to-many relationship with OrderLine called lines.
- OrderLine has the inverse called order.
- Both entities have a common key called orderKey.
Using For loops on the Order entity and then filtering the OrderLine and adding them to the Order is way too slow. I am hoping that there is a way to do a batch update on the relationship or what would be the best way to match up the data in the two entities.
I'm using Swift 5.5
Thanks in advance!