Question Guillaume Rongier · Jan 21, 2019 JDBC batch insert Hi, I'm looking for a way to implement the JDBC pattern "executeBatch" in ObjectScript: https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htmSince Ensemble 2017.2.2 there is a new method called executeParametersBatch : https://docs.intersystems.com/ens20172/csp/docbook/relnotes/index.html#D... #JDBC #SQL #Ensemble 1 4 0 633
Question Guillaume Rongier · Sep 20, 2018 JDBC Large query optimisation Hi, We recover a large amount of data from an external database (SQLServer, about 1 million rows in JDBC).However, we have treatment time issue.This process takes more than 30 minutes whereas on a "classic" SQL Server Management Studio type request takes less than a minute. #Database Transaction Processing #Ensemble #Business Operation #JDBC 1 7 1 1.2K