不使用CDbcache 对表操作2次
12:50:17.693025 trace system.db.CDbConnection Opening DB connection
12:50:17.704546 trace system.db.CDbCommand Querying SQL: SHOW COLUMNS FROM forums
12:50:17.714440 trace system.db.CDbCommand Querying SQL: SHOW CREATE TABLE forums
使用CDbcache 对表操作3次
13:03:10.60539 trace system.db.CDbConnection Opening DB connection
13:03:10.66075 trace system.db.CDbCommand Executing SQL: DELETE FROM YiiCache WHERE expire>0 AND expire<1244552590
13:03:10.66792 trace system.db.CDbCommand Querying SQL: SELECT value FROM YiiCache WHERE id='01ea9e1e8ffda0be923294008797b0ba' AND (expire=0 OR expire>1244552590)
13:03:10.102530 trace system.db.CDbCommand Querying SQL: SELECT value FROM YiiCache WHERE id='948dc9a84bd5dcc3b31f9bc3374533ee' AND (expire=0 OR expire>1244552590)
怎么弄都是影响效率的
怎么在model里定死 反正表的字段一般不会变的 手工定义也不麻烦啊
效率效率