Re: Optimization of application to reduce db workload and improve performance

[Jan Becker]

> 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 (https://www.winautomation.com/). 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.