Hello I've been working in an integration between SyteLine and an external application to create journal entries. I created a custom table and its IDO to receive records that are validated with an event handler linked to that IDO with the IDOOnItemInsert event. The handler basically does some validations, then create the journal entry with the IDO Method JourpostSp, and then add some notes to the new journal entries with the method CUNotesSp. I've notice it takes a long time to process the records… with a batch of 500 records it last almost half an hour.
Do you know a way to optimize it? Does the IDOOnCollectionInsert is faster? Or should I migrate this process to a SP or an extension class method?
Regards.
