go to post Guillaume Rongier · Sep 20, 2018 Hi Marc, I'm intereded by your sample code for this kind of optimisation even if we have to use a different EnsLib.SQL.GatewayResultSet. Furthermore, we are currently looking for the same kind of optimisation in the other way, insert in JDBC batch mode. (https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htm) I get in touch with our Sales Engineer and we will continu to discuss this by email. When we will have improvement, i'll update this theard.
go to post Guillaume Rongier · May 31, 2017 Hi, Have you try to type your SQL parameters : set param(i,"SqlType") = 12 //12 for SQL_VarCharI hope this will help you.