Simpel call very slow (too many relations?)

Yii 2.0 General Discussions
1

I am building my first yii2 app and I am really enjoying it.

Now I created a new table (25 columns with text fields)

that has 2 foreign keys

Another table links to this primary table, and this second table has 5 foreign keys

There 2 rows in every table

Now after creating the models, crud with GII

the primary table does show the information, however it takes a whopping 30+ seconds to do so.

What am I overlooking?

Are there too many relations ?

Maybe too many colums with plain text ?

2

Post the code, so it seems all right.

3

Where is the query the require 30+ seconds to be executed?

4

How can you be sure that time is taken from the query?

5

I just used the plain gii code, no edits

6

I know when I used the same procedure (just gii) for another table. that loaded fine, this ‘emap’ index page takes 30 seconds (I am counting the seconds manually on my watch)

7

If you are calling ‘index’ action, I’ll put a var_dump immediatety after the data provider initialization and getModel() call.




    public function actionIndex()

    {

        $searchModel = new EmapSearch();

        $dataProvider = $searchModel->search(Yii::$app->request->queryParams);


        // This call is needed to load all data provider data

        $item = $dataProvider->getModels();


        var_dump('all items loaded');  

        exit;   // action stops here




        return $this->render('index', [

            'searchModel' => $searchModel,

            'dataProvider' => $dataProvider,

        ]);

    }
8

One thing I would suspect is that you are missing some indexes on your table…

9

BRILLIANT !!!

That suggestion peeked my interest. Although it was not a index problem, but another problem related to an event handler that was called many many times

Thanks guys !!!