Post

Replies

Boosts

Views

Activity

Batch Update for Relationships
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!
0
0
406
May ’23