in my test mongrel server output for a page, 8 queries are listed but many more DB are counted:
Query1 Query2 ... Query8 Rendered Partial1 Rendered Partial2 .. Rendered Partial40 Completed in 4754ms (View: 308, DB: 2246) | 200 OK
how do I show all the queries that are running?
Also, is there documentation for what the View; count represents?
I m not sure I understand the question, but are you asking what the number after DB means? If so, it s the number of records returned.
Some sample output from my Mongrel server:
Processing AlbumsController#show to xml (for 127.0.0.1 at 2009-12-22 06:44:38) [GET]
Parameters: {"format"=>"xml", "action"=>"show", "id"=>"1", "controller"=>"albums"}
Album Load (0.1ms) SELECT * FROM `albums` WHERE (`albums`.`id` = 1 ) LIMIT 1
Album Columns (0.8ms) SHOW FIELDS FROM `albums`
Artist Columns (2.0ms) SHOW FIELDS FROM `artists`
Artist Load (0.1ms) SELECT * FROM `artists` WHERE (`artists`.`id` = 1)
Track Load (0.1ms) SELECT * FROM `tracks` WHERE (`tracks`.album_id = 1)
Track Columns (1.3ms) SHOW FIELDS FROM `tracks`
Completed in 48ms (View: 1, DB: 22) | 200 OK [http://localhost/albums/1.xml]
You see only 3 queries here, but 22 records are returned. If you want to see all of the records that are being shown, display them in your templates. Or, you could easily display them in XML in your controller.
def index
@records = Record.find(:all)
respond_to do |format|
format.xml { render :xml => @records }
end
end
Long story short, you are seeing all of the queries.
collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...
We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...
As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...
I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?
I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...
I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml
guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...