When using the Create Feature Layer action, by default the Location Type is set to "Automatic (find in file)". Upon running the Flow, all records are inserted as a batch. Approx 10 minutes for 5000 records.
If Location Type is changed to "Coordinates" and XY fields are specified, the create process becomes a loop with the Apply to Each action. This greatly impacts performance, taking approx. 2 hours with the exact same data. The loop is the only difference.
Same outcome with explicit "ID Column" or Field Mapping options using the Create a Record in a Feature Layer action.
Is it possible to maintain the batch/bulk insert/create operation when using an explicit Location Type or ID Column?
For reference, the input is a table queried from SQL Server. Images attached