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!