Every time a table is accessed there are these queries (e.g. for the "users" table):

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

system.db.CDbCommand.query(SHOW CREATE TABLE `users`)

I have APC installed and use it extensively to cache variables and such. Is there a way to set Yii so that these queries are cached? I know there are only small queries, but the number of queries count too.

If there isn’t a way of caching them, then why not?

I think it’s diferent way to cache system schema as written here:

If the application is using Active Record, we should turn on the schema caching to save the time of parsing database schema. This can be done by configuring the CDbConnection::schemaCachingDuration property to be a value greater than 0.

You can found this here:

There is other great topics about Yii performance ;)

That’s exactly what I was looking for, thank you!