MySQL Forums
Forum List  »  Connector/ODBC

Re: Inserting a record is very slow and fails with database with 20k+ records
Posted by: Bogdan Degtyariov
Date: June 12, 2023 08:57PM

Hi Leo,

The symptoms like you described are often originating from the driver caching of the resultset. The typical scenario is when ADO object does the full table select without actually using the results. In this case the ODBC driver might cache the table rows, which could take significant memory and time.

To skip caching of the results you can add "NO_CACHE=1" to your connection string or in the ODBC Administrator GUI dialog tick "Details >> Cursors/Results >> [x] Don't cache results of forward-only cursors."

What is the exact error message your application is displaying?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Re: Inserting a record is very slow and fails with database with 20k+ records
June 12, 2023 08:57PM


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.