Too Much Relations Could Make The Server Slow?

Yii 1.1 General Discussion
1

I know that the relation in the model will help the model wrap as much as possible tables and column depends on the conditions. If currently I have 20 tables and more than 50 relations. I feel that it is slower than before. Could it happen? :lol:

2

see this http://www.yiiframework.com/doc/guide/1.1/en/topics.performance

3

use

http://www.yiiframework.com/extension/yii-debug-toolbar/

to see sql e memory usage

4

Hi clonevn

Except the advices of @jneto and @fburhan89 I question you …

  1. Is it nessesary this task to completed on one request?

  2. This task must be done on every request ?

  3. May be have to thing a cron job task every certainly time or using Yii cashing system

Post more specific details :)

5

Hi

Personally I do not think that relations are making things slower unless the requests themselves are not efficient.

I noticed recently that setting up behaviors is slow (see http://www.yiiframework.com/forum/index.php/topic/42954-performance-impact-of-behaviors/page__view__findpost__p__204540 for a workaround) and to find what is slow for you, profiling may help you to the anwser.

6

Thank you all for your ideas. My table is big because of too many exception and one models could do 3 tasks differently. That’s why it is big, could not change anything in the database. This time is about optimizing the system. I will try your suggestion and get back later :).