After several iterations of hardcoding fields and running in real instead of draft mode, the fastest import into nsC7InventoryTransactionsHeader seems to be 5 records/sec. Is that the best I can expect or is there more I can do. Some things like owner and order lookup I don’t feel should be hardcoded to Nextworld ID, what else can be done or is that what is to be expected? With over 680k records to import that will take 38 hours.
For data imports to be most performant, the target table needs to satisfy the conditions laid out below for Optimized Import Mode:
It sounds like that table may not satisfy the criteria - a SME would need to confirm. Creating a simpler integration table that does satisfy the criteria, and the processing the records in that table into nsC7InventoryTransactionsHeader using parallel processing may need to be considered.