Multi Insert with $BATCH or XSJS for better performance

[former_member216577]

Hi Expert,

We have requirement to insert multiple record in 3 tables.

Table1 -Header

Table2 - Item2

Table3 - Item3

We have two approach, first one is to use $BATCH and second to use .XSJS

In $batch we are sending multiple record in batch request

In XSJS we are sending the request in DEEP_INSERT format by calling the service

https://<>/services/itemCreate.xsjs

{

Header

"Item1":[{

}],

"Item2":[{

}]

}

which approach we need to follow for better performance?

Regards,

Anurag Singh

[former_member590745]

We have an issue with slow inserts in XSJS.

Did you solve the described task?

If so is it fast, how many rows?