How 'Batch size' works in Import set?

[Suggy]

I have 50 records in excel, used the batch size of 5.

My expectation was 10 import sets should get created (50/5=10), but only 1 import set got created.

Q - Is my understanding right that 10 ISETs should get created? If yes, then why only 1 ISET got created during my testing? 🙂

Note - I have even set the system properties like below:

glide.import_set_load_usebatch = TRUE

glide.import_set_load_batch_size = 5

[Anand Kumar P · Accepted solution]

Hi @Suggy ,

ServiceNow will process the 50 records in groups of 5. This means there will be 10 batches, each containing 5 records. All these records are part of a single import operation, but processing them in smaller batches can make the import more efficient and reduce the chance of system overload.

check below doc for more info 

https://www.servicenow.com/docs/bundle/xanadu-integrate-applications/page/administer/import-sets/ref...

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand

[Ankur Bawiskar]

@Suggy 

that's not the correct interpretation.

Our understanding that 10 import sets (ISETs) should be created when using a batch size of 5 for 50 records is logical. However, in ServiceNow, the creation of import sets doesn't always work exactly this way due to several factors.

Basically the batch size setting determines how many records are processed at a time, but it doesn't necessarily mean that a new import set will be created for each batch. Instead, it controls the number of records processed in each transaction to manage performance.

If my response helped please mark it correct and close the thread so that it benefits future readers.