Why each request with activerecord is doing SHOW TABLE?

Posted by dynback.com on Stack Overflow See other posts from Stack Overflow or by dynback.com
Published on 2010-04-15T17:59:47Z Indexed on 2010/04/15 18:03 UTC
Read the original article Hit count: 146

Filed under:

yii

|

activerecord

My test page is processed if believe to trace in 46 ms, while 11 of them I am doing this

 20:53:06.111597 system.db.CDbConnection   Opening DB connection
 20:53:06.118046 system.db.CDbCommand      Querying SQL: SHOW COLUMNS FROM `questions`
 20:53:06.122476 system.db.CDbCommand      Querying SQL: SHOW CREATE TABLE `questions`

Is this obligatory?

© Stack Overflow or respective owner

Related posts about yii

How does one track down an error using the YII Framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am learning the Yii Framework and I got this error wich does not really point to the specific pages I am working on or as far as i can tell show me where I should start looking for my problem. How do I make sense of this? As far as I can see all my 'type_id' references are typed in correctly. … >>> More
Yii urlManager language in URL

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to add a language to the url with following syntax: http://www.example.com/en/site/page/view/about What I have so far works with short urls like: http://www.example.com/en/site/contact but not with long once as in my first example Here is what I have so far: /config/main.php 'urlManager'=>array( … >>> More
"Admin module" taking over [Yii framework]

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have an "admin" module and I want it to serve "dynamic controllers", i.e. to provide a default behaviour for controllers which don't really exist ("virtual controllers"). I've invented a lightweight messaging mechanism for loose communication between modules. I'd like to use it such that when… >>> More
Experience using Yii framework for actual PHP project

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been using Code Igniter for my PHP projects, when I start them from the beginning. It is very nice framework, saves me a lot of work and let me have low level access if I need to do something special. Code Igniter is also faster then similar frameworks by order of magnitude. I came across Yii… >>> More
Problem with a test method in Yii web services

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, Is there anyone here who might be familiar with web services in the yii framework? I declared the following test method: /** * Send a single SMS message * * @param string $username Username * @param string $password Password * @param string $identifier Valid Identifier to… >>> More

Related posts about activerecord

Rails & ActiveRecord: Appending methods to models that inherit from ActiveRecord::Base

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a standard ActiveRecord model with the following: class MyModel < ActiveRecord::Base custom_method :first_field, :second_field end At the moment, that custom_method is picked up by a module sent to ActiveRecord::Base. The functionality basically works, but of course, it attaches itself… >>> More
Rails ActiveRecord - Best way to perform an include?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have three models: class Book < ActiveRecord::Base has_many :collections has_many :users, :through => :collections end class User < ActiveRecord::Base has_many :collections has_many :books, :through => :collections end class Collection < ActiveRecord::Base belongs_to… >>> More
Getting types of the attributes in an ActiveRecord object

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know if it is possible to get the types (as known by AR - eg in the migration script and database) programmatically (I know the data exists in there somewhere). For example, I can deal with all the attribute names: ar.attribute_names.each { |name| puts name } .attributes just… >>> More
Changing ActiveRecord attribute value in before_save hook

as seen on Stack Overflow - Search for 'Stack Overflow'
I needed to fix the encoding of an ActiveRecord attribute and decided to do it in a before_save hook. And at this point I noticed an unexpected feature. When I wanted to change the value of the attribute, simple using the attribute_name=XY did not work as I expected. Instead of that I needed to use… >>> More
Conditions with whitespaces in activerecord find

as seen on Stack Overflow - Search for 'Stack Overflow'
So i am trying to do this Order.find :all, :conditions => "org = 'test org'" what ends up firing is SELECT * FROM `orders` WHERE (org = 'test org') the whitespace in the argument gets stripped. what am i missing.. im really stumped here. please help! >>> More