similar to: find_by_sql preformance problems when ordering data

Displaying 20 results from an estimated 10000 matches similar to: "find_by_sql preformance problems when ordering data"

2007 May 21
4
Spec''ing redirect with arbitrary parameters
I''ve got the following expectation: response.should redirect_to(:action => "new", :video_id => "1", :process_id => "2", :origin_id => "3") that fails with this error message: expected redirect to {:video_id=>"1", :process_id=>"2", :origin_id=>"3", :action=>"new"}, got redirect to
2012 Feb 07
2
save method (create action) saves twice
Rails 3.1.3 I have changed a regular scaffold action a bit so that it can save using ajax. All I needed to do was adding ":remote => true" in <div id="script_new"> <%= form_for script, :remote => true do |f| %> <!-- HERE!!! --> <%= f.hidden_field :video_id %> <%= f.text_field :text %> <%= f.submit "save" %>
2008 May 21
6
this.initialize has no properties error in Prototype Code
Hi All, I''m a super newbie with Prototype and am trying to implement my first solution using it. This is my code: var span = ''totalViews'' + video_id; var params = ''video_id='' + video_id; Ajax.Response(''trackVideo.php'', { method: ''post'', parameters: params, onSuccess: function(transport) {
2012 Feb 22
3
Parent id for find_or_create method
Rails 3.1.3 I have tables, Video and Script having association, Video 1 --- n Script So, every Script needs the parent id, in this case, video_id. If I simply create a new Script instance, the view renders as follows. <%= render :partial => "new_script", :locals => { :script => Script.new(:video_id => @video.id)} %> which works fine. Now I would like to
2006 May 13
4
undesireable lazy loading
Hi, My work with Rails has been fairly straightforward, until yesterday... I''ve encountered rather a peculiar problem that I''m not able to solve myself as a rails-newbie. The model code looks like this: class Link < ActiveRecord::Base has_one :user_vote end class UserVote < ActiveRecord::Base belongs_to :user belongs_to :link end I have a SQL query that is
2009 Nov 09
3
How can I improve a Ruby on Rails code that hast a lot of SQL as strings?
Hello Railists, I have a piece of Ruby on Rails code that has a complex SQL query (well, not that complex, but as far as I know beyond the ORM capabilities) and for my taste it has too many strings and harcoded values. I''d like to improve it as much as possible, so my question is open ended, what else can I do to improve it? Some particular issues I have - Is there a way to get a table
2007 Feb 23
4
How can I spec this? The method gets passed a block...
I''m using Jim Weirich''s Builder library. The code I want to spec is xml.video do xml.id @video_id xml.views @views xml.date(@date.to_s) if @date end I''d like to mock it, rather than asserting that the XML is the right string. I can do one spec: specify "should create a video tag" do @mock_builder.should_receive(:video)
2007 Feb 21
1
Rendering all the elements when calling Array#to_xml
When I call to_xml on an array, I want it to get the XML for all the elements in it. I''ve defined to_xml in my class. >> r.to_xml => "<video><id>1</id><views>2</views></video>" >> a = [r] => [#<StatisticsReport:0x3259f38 @video_id=1, @views=2>] >> a.to_xml => "<?xml version=\"1.0\"
2006 Jan 17
4
find_by_sql column ordering defect?
Hello. I have a program that accesses a metadata (translation) table for column names as well as the ordering of columns for a specific model. Also in there is a collection of bool options such as column_visible_on_form, column_visible_on_screen_quicklist etc. The idea is that our customer can specify to a certain extent how their layout/user interface will appear. To accomplish this, I use
2011 Jan 15
3
respond_with javascript
My ajax stopped working when I switched to using respond_with. For my Votes, I have the create action and the corresponding create.js.erb, and respond_to :html, :js, :xml in the controller. Heres the log when I try and create a vote: Started POST "/stories/3-asdfasdf1111/votes" for 127.0.0.1 at Fri Jan 14 20:46:36 -0800 2011 Processing by VotesController#create as */* Parameters:
2012 Oct 11
2
survey package question
Hello, I have got a cluster sample using an election dataset where I already had the final results of a county-specific election. I am trying to figure out what would be the best sampling design for my data. The structure of the dataset is: 1) polling station (in general schools where people vote, for a county, for example, there are 15 polling stations) 2) inside each polling station, there
2008 Nov 20
1
binomial glm???
Hi everyone, newbee query! I've installed R 2.8.0 and tried to run this simple glm - x is no of cars in a given year, y is the number voted in an election that year while n is the population 18+: votes <- data.frame(x = c(0.62,0.77,0.71,0.74,0.77,0.86,1.13,1.44), + y=c(502,542,711,653,771,806,934,1123), n=
2007 Dec 22
3
Erlang DTrace Provider
DTrace folks, I''m pleased to introduce a potential new DTrace-sponsored project: the Erlang DTrace provider. To be good OpenSolaris citizens, we want to put the formation of this officially sponsored project to a vote -- as outlined in the OpenSolaris Constitution -- so here are the details for the new Project, as prepared by the Project Team: Name : Erlang DTrace Integration
2007 Dec 20
3
ActiveRecords Eager Loading
Hi, I am doing an eager loading in ruby on rails using below statement ------------------------ Article.find(:all, :include => [:asset, :vote], :conditions=>"assets.parent_id is null", :order=>"stat_final_ranking desc", :limit=>20) --------------------------------------- the above statement resulted in this expensive query.
2008 Jan 17
3
Help with Error
Hi, I am having trouble with an error I keep getting. I am just trying to create a simple pic chart from a small table. Hope someone can help. I am new to R. Table: Name Votes John 300 Sean 222 Andy 467 Sinead 740 David 124 James 641 William 380 Commands: d <- read.table("C:\\rep.csv", head=TRUE, sep=",") > pie(d$Votes, +
2006 Feb 18
0
Preformance counters
Hi, Does samba has any performance or statistical counters that could be used to analyze server usage with MRTG, RRD or other statistical tools? Thanks Gil
1998 Nov 12
1
Windows 98 Preformance
I have Samba on a HP-UX 10.20 box and a Windows 98 and NT clients. We are using Samba to just share the Unix drives, the clients get their main stuff from an NT domain structure. On my NT client connected to a share, when I go into file manager for an example I get the directory structure almost instantly. However when the 98 client does the same exact process on the same exact share, it take
2005 Apr 15
1
Poor Samba Preformance
I recently upgraded a part of my network to Gigabit ethernet, basically between my Linux machine and my main windows machine, is now gigabit. The problem is that, and the whole reason I went with it, is to get faster speeds with samba. I've only been able to get 13.4 MB/s as a maximum transfer speed. I don't expect to be able to get 125 MB/s. If I use HTTP I can get around 18 MB/s,
2007 Mar 28
7
Rails, REST and JSON
Hi everyone, I''m writing a lightweight AJAX application using Rails on the server side as a RESTful web service provider. I need the web service to support both JSON and XML I/O. Outputting data in XML and JSON is easy (using to_xml and to_json), and it''s also easy to do XML input as Rails does it for you automatically. Is it possible to somehow have the same automatic parsing
2011 Sep 11
1
[XCP] primary/primary DRBD 8.4.0-1 LVM-based shared SR (xcp 1.1) preformance tuning
Hi all, we have followed the very good HOWTO by http://wherethebitsroam.com/blogs/jeffw/drbd-xcp-05 and set up DRBD on XCP 1.1 in primary/primary mode. It works fine, but I am wondering how to squeeze more performance out of the system (we currently use a crossover GB Ethernet connection). When writing a 1 GB file on a guest I get write performance of about 5MB/s (idle). We have disabled all