Re: real time performance issues

[Peter Brawley]

The stored procedure uses a cursor? Most cursors can be replaced by equivalent sql which runs an order of magnitude faster.

It's much easier to optimise a query once it\s extracted from an sproc. Read about Explain ...

https://dev.mysql.com/doc/refman/5.7/en/explain.html

https://dev.mysql.com/doc/refman/5.7/en/explain-output.html

https://www.eversql.com/mysql-explain-example-explaining-mysql-explain-using-stackoverflow-data/

then run Explain format=json (or in 8.0, explain analyze), optimise query index use and other problems in it.



Edited 1 time(s). Last edit at 03/28/2020 11:19AM by Peter Brawley.