Slow filling data
Posted by: Сергей Щёголев
Date: July 22, 2020 01:15AM

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().

Options: ReplyQuote


Subject
Written By
Posted
Slow filling data
July 22, 2020 01:15AM


Sorry, only registered users may post in this forum.

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.