MySQL Forums
Forum List  »  Connector/ODBC

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Inserting a record is very slow and fails with database with 20k+ records
Leo Ayala
May 22, 2023 07:55PM
Re: Inserting a record is very slow and fails with database with 20k+ records
Bogdan Degtyariov
June 12, 2023 08:57PM


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.