Hello everyone,
The Prebuilt ODBCConnection feature is slow to read data from an SQL Server Database. If I query my data with SSMS, it takes 6 seconds (31 queries).
Querying the same data with Cplex OPL 22.1.0 ODBCConnection, take more than 26 minutes (for a problem that solves in less than 40 seconds). Using the Cplex OPL 12.6.3 version old DBLink load and solve the problem in less than 2 minutes. Inserting data in the database is longer and I can't use it.
Did someone know a hint to insert in the connection string to solve my problem?
------------------------------
Marko BLAIS
------------------------------
#DecisionOptimization