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 (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.
Subject
Written By
Posted
December 15, 2018 03:57PM
December 15, 2018 03:59PM
December 15, 2018 04:11PM
Re: Optimization of application to reduce db workload and improve performance
December 15, 2018 04:31PM
December 15, 2018 06:00PM
December 16, 2018 04:58PM
December 16, 2018 08:00PM
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.