I'm building a few transforms that insert data from an SQL view to an Orchid Extender table in Sage 300.

The last one I did is meant to insert about 112,000 rows to the table. Is that too much? I got a 'timeout' message on the scheduler screen, and when I query the AUDITLOG table I see that the process started but did not stop. No errors. Server seems to be sluggish as well, so I'm not sure where/how to isolate the issue.

Just curious if in general I should build a transform to handle the first X rows of data, then do a second pass that handles the next X rows that have not already been processed, or what the best practice should be there.

Thanks for any advice.