MySQL Forums
Forum List  »  Connector/ODBC

Re: Optimization of application to reduce db workload and improve performance
Posted by: Jan Becker
Date: December 15, 2018 04:31PM

> Does that occasion swapping? If so there's a major slowdown cause.

Occasion swapping? Never heard. Probably not. Where can I find documentation about this?

> ODBCis useful because it works with so many different frontends and backends. That flexibility costs performance. Why are you using it?

The application is built with WinAutomation ( This uses ODBC.

> Yikes, is the app using MyISAM!?

Yes. Shall I change that? Would it be possible to just change it for this one table? I don't remember exactly the reason for using this.

What about the idea of retrieving e. g. 10 tasks at a time. When the SQL statement just requires 0.005 seconds, would this not be a good idea? I do the database part and a friend of mine the WinAutomation part. It's unclear how to measure it. If doe in WinAutomation, the measurement as such would create a delay, as far as I understand. Also the time measurement is not always correct. E.g. if he puts a "wait 5 seconds" statement, it waits sometimes more and sometimes less time. Thus the results might be misleading.

Options: ReplyQuote

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.