I'm creating an application in 64-bit Windows that extracts data from AS400 using IBM Client Access 64-bit ODBC. Issue is when query is running on AS400, it is very slow compared to other executing queries, time waits and pulls records back to my server a few at a time. Trouble must be with IBM Client Access 64-bit ODBC driver, which I am required to use to access AS400 directly, but need to improve performance significantly.
No help from IBM yet, and hoping to for suggestions on performance settings or alternative solutions.
Please let me know your thoughts.