system.db.CDbConnection taking more than 1 second to execute in yii

Question

I am a new to yii although i have worked a lot with codeigniter and was just trying to convert my code from codeigniter to yii But the CDbconnection is taking more than 1 second to execute i have attached a screenshot. also the sql code i am using.

$criteria = new CDbCriteria();
$criteria->select = "total_photos";

$data = array( 'Gallerys' => Gallerynames::model()->findAll($criteria));

Please look into it Screen shot of the log

Edit:

Here is my db config

'db'=>array(
        'class' => 'system.db.CDbConnection',
        'connectionString' => 'mysql:host=localhost;dbname=yiiwiki',
        'emulatePrepare' => true,
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8',
        'enableProfiling' => true,
        'schemaCachingDuration' => 3600,
    ),

also same thing in codeigniter is taking less than 0.004 sec. — Anand mohan sinha, Aug 20 '12 at 07:09

score 2 · Accepted Answer · edited May 23 '17 at 12:20

2

From yii guide

Because ActiveRecord relies on the metadata about tables to determine the column information, it takes time to read the metadata and analyze it. This may not be a problem during development stage, but for an application running in production mode, it is a total waste of time if the database schema does not change.

so set the schemaCachingDuration of the db application component a value greater than zero. 'db'=>array( 'class'=>'system.db.CDbConnection', 'connectionString'=>'sqlite:/wwwroot/blog/protected/data/blog.db', 'schemaCachingDuration'=>3600, ),

Keep in mind that you should specify a valid cache in the application config

EDIT It seems your problem is not due to the schema. Refering to this changing localhost to 127.0.0.1 will fix it

edited May 23 '17 at 12:20

Community

1
1

answered Aug 20 '12 at 08:11

dInGd0nG

4,162
1
24
37

if you check out the time at which the log messages were posted, you can see that _opening_ the connection takes long, not _reading_ the schema. see the 2nd and 3rd row of messages in the pic. – bool.dev Aug 20 '12 at 08:53
Ya i am also talking about the same that connection is taking longer – Anand mohan sinha Aug 20 '12 at 09:11
Applied what you said still no improvement. – Anand mohan sinha Aug 20 '12 at 09:11
oh my mistake. Btw changing the 'localhost' in connection string to '127.0.0.1' makes any difference? – dInGd0nG Aug 20 '12 at 11:19
Ya thank that was the solution this was also suggested by a guy on the forum thanks – Anand mohan sinha Aug 20 '12 at 14:39

system.db.CDbConnection taking more than 1 second to execute in yii

1 Answers1