Slow filling data
Why filling in data when using MySQL Connector/Net works 10-20 times slower than when using a ODBC connector OdbcDataAdapter Fill()? The body of the query or stored procedure is the same.
This effect is observed when using the methods MySqlDataAdapter Fill() and DataTable Load() from MySqlDataReader.
Version of Connector/Net - 6.9.1
Version of Connector ODBC - 5.1
None of the recommendations that I found on the Internet affect this in any way. For example, DataSet property EnforceConstraints = false and DataTable methods
BeginLoadData() and EndLoadData().
Subject
Written By
Posted
Slow filling data
July 22, 2020 01:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.