Periodically slows down Yii. How to fix?

L

Lomoson2014-01-10 19:15:01

Yii

Lomoson, 2014-01-10 19:15:01

I'm making the first site on Yii and stumbled upon such a problem as page generation speed.
The problem is that ten times the page loads quickly, and then it takes 5 seconds. Sometimes the request to the database takes several seconds.
Tell me, please, is this most likely related to the server, or did I overdo something with Yii?
In Log Messages between messages:
Loading "messages" application component trace system.CModule
Loading "widgetFactory" application component trace system.CModule
takes 5 seconds, this seems to be the problem.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Sergey, 2014-01-10
Protko @Fesor

You have troubles with the database and sql queries. Most likely, queries that are executed quickly are those that mysql issues from the cache. Disable caching in mysql on the local, profile queries, find what exactly slows down and fix it.

L

Lomoson, 2014-01-10
@Lomoson

In Log Messages:
Loading "messages" application component trace system.CModule 19:19:41.632607
Loading "widgetFactory" application component trace system.CModule 19:19:46.834880
It turns out 5 seconds are lost here.
Can you please tell me what can be done about it?