Sql project speed decreased

[shiva4]

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.

[shiva4]

I wanted to clarify. version of Mysql was 5.7.19 and changed to 5.7.22

[shiva4]

I'll make an adjustment. "Toad for my sql" also works slowly.

[shiva4]

Understood with the question. The topic is closed.