2
This explanation there is no need for code, it is more a question of database logic even. What is happening:
I have an application using Codeigniter and Mysql, and it has 4 actors, but in one of these actors, the more you loga, longer it takes to load. It seems like the more I soon, the more the bank gets "overloaded" (which does not happen with the other actors, and even has two that bring many more relationships in the bank than this).
For example, loguei once it takes around 5-7 seconds to load the main page. If I offset and log in again it will take around 10 seconds and so on (to the point of getting practically "unapproachable" so long). It is not a matter of code because I made a function that returned practically nothing (only the view with basic html), and took anyway.
Important detail: In my place does not happen this, always load fast.
Make sure the tables are as innoDB. This property is typical for manipulation with read and write data. While Isan is more for data reading.
– André Nascimento
Check if there is any open transaction.
– user6406
Yes, it’s in innoDB.
– Jonathan Machado
As a matter of fact, you’ve already solved it, if so what the solution was and what it was?
– Marcelo Diniz
No, in vdd I checked the code and I was able to soften the situation. But it continues with the "overload" only in a less worrying way
– Jonathan Machado