schemaCachingDuration

Yii 1.1 General Discussion
1

I’ve set schemaCachingDuration in my config, but the profile is still showing lots of calls to ‘SHOW COLUMNS FROM’ etc. Any ideas?

config:




...


		'db' => array(

			'connectionString' => 'hidden',

			'emulatePrepare' => true,

			'username' => 'root',

			'password' => 'hidden',

			'charset' => 'utf8',

			'tablePrefix' => '',

			'enableProfiling' => true,

			'schemaCachingDuration' => 100,

		),

...

Example profile results…




system.db.CDbCommand.query(SHOW COLUMNS FROM `algo_extra`) 	1 	0.00366 	0.00366 	0.00366 	0.00366

system.db.CDbCommand.query(SHOW COLUMNS FROM `site_access`) 	1 	0.00354 	0.00354 	0.00354 	0.00354

system.db.CDbCommand.query(SHOW COLUMNS FROM `user`)

......
2

You do have a cache component configured, right?

3

E.g., cache to file is configured with :




'cache'=>array(

   'class'=>'system.caching.CFileCache',

),

In the same section with the ‘db’ setting in your config file.