SQL SHOW queries

Hi all,

When i run profiling on my website, i can see that Yii perfoms 4 SQL quries, 2 x SHOW COLUMNS FROM and 2 x SHOW CREATE TABLE.

Why does it this, and how can i disable it to minimize execution time?

I thought that some files might not had write access, in order to store this information, but which files needs this?

It’s for active record functionality. For production you can turn on schema caching via following connection setting:


Okay, i did: ‘schemaCachingDuration’ => 3600 but i see no changes :(

I think you have to specify a Caching method in your config too.

Adding this worked for me:






	'class' => 'CFileCache',


See http://www.yiiframework.com/doc/guide/caching.overview for more info on the various caching classes.

Worked perfectly, thanks!