A Dataflex 18.2 application migrated to Datalex 19.0 exhibits significantly slower performance in fetching data from the SQL source.

For testing, the 18.2 Version and 19.0 version are accessing the same SQL backend using the same ODBC connection.

SQL Backend: MariaDB Version 10.2
ODBC Driver: 32 bit MySQL ODBC ANSI version 5.3

The application fills a cDbCJGrid, fetching approx. 1000 rows.

In my development environment DataFlex 18.2 fills and shows the grid immediately i.e. 1 second or less.
The Dataflex 19.0 application, same code as 18.2 complied for 19.0 takes close to 6 seconds to fill and show the grid.

There is no embedded SQL in the code.

My customers environment is a little less friendly, with these results.

Dataflex 18.2 fill and show the grid about 1 second.
Dataflex 19.0 fill and show the grid around 20 seconds.

For version 19.0 I have tested with Managed Connections and legacy driver configurations to observer the same degradation of performance.

Has anyone observed this slower performance of version 19.0 and is so has a solution been found to get back to 18.2 performance.

Kind Regards

Danny