I've been working on an integration between SyteLine and an external app via the SyteLine API REST. The purpose is to create new journal entries, and to achieve that I created a new table with its IDO to receive the data, and then with an AES event handler linked to that IDO with the IDOOnItemInsert I do some validations, create the journal entries with the JourpostSp IDO method, and finally add some notes to the new entries with the CUNotesSp method. But I'm noticing it takes too much time to process the data. For example with a batch of 500 records takes almost half an hour.
Is there a way to optimize an event handler? Do you know if the IDOOnCollectionInsert is faster (and how does it work because the documentation is really vague)? Or should I migrate that process to a SQL trigger or a IDO extension class?
Regards.
