Problem:

Any directives or tips to help performance, not using cursors

doing select into an array

Resolution:

Following made a significant improvement in performance:

1. move sql directives to sql program only (remove from project properties)

2. remove autocommit and thread=isolate

add autofetch

remaining directives were targetdb=mssqlserver ansi92entry esqlversion=3