I have a list which contains 3 fields. 2 other fields are outside the list. I need to get this insert in a database table.
Which is these 2 scenarios are efficient in terms of performance & tuning ?
Use batch (local) insert for the list and use update (No) for the other 2 fields.
Use appendToDocumentList to create the list of 5 fields. Use batch (local) to insert the list
Loop over the list and insert (No) one at a time all 5 fields.
Is there is any other scenario that I missed but is efficient ?