Sql project speed decreased
Posted: 23.06.2018, 11:42
Hello.
There is such a development of "LimeSurvey" which uses the Mysql database (v.5.7).
I wrote the program on delphi 5 and ZEOSDBO-6.6.5-stable which executes sql query to several mysql database tables (v.5.7). This sql-request was executed less than 1 second. Recently I had to change the version of LimeSurvey (deleted the past and installed a new one).
As a result, on the same version 5.7 of MySql, the speed of execution of the same request fell 20-40 times. At the same time, if the same Sql request is executed via "Toad for MySql", the request is executed less than 1 second.
I have an assumption that in the database settings something has changed .. but where to look I do not know. Help please solve this problem! Return to the previous version is not an option.
There is such a development of "LimeSurvey" which uses the Mysql database (v.5.7).
I wrote the program on delphi 5 and ZEOSDBO-6.6.5-stable which executes sql query to several mysql database tables (v.5.7). This sql-request was executed less than 1 second. Recently I had to change the version of LimeSurvey (deleted the past and installed a new one).
As a result, on the same version 5.7 of MySql, the speed of execution of the same request fell 20-40 times. At the same time, if the same Sql request is executed via "Toad for MySql", the request is executed less than 1 second.
I have an assumption that in the database settings something has changed .. but where to look I do not know. Help please solve this problem! Return to the previous version is not an option.