similar to: MySQL query optimization

Hi, I am not sure if this is a general web question or a Rails specific one but either way, I would really appreciate help and guidance. My application generates quotes. To do so, you start at a page that has the client details. From there you go to a catalog (a link on the quote page) and select the items that are to be in the quote. All the above is working just fine. My problem is that when

Hello list. We just upgraded to 1.6.1.11. We are using real time information stored on mysql databases. That is all running fine. Now, since we upgraded, some member don't get calls from queues. In CLI: "queue show" shows something like: 611 (Local/611 at agents) with penalty 20 (realtime) (*In use*) has taken no calls yet We use the extension 611 in different computers, in the

I have a site running the current version of Centos 4.2, it has a shopping cart running on it and runs slow and times out at random. The cart is a simple php package using a MySQL database backend. Can any one think of ways to improve the speed in MySQL and Apache, I've had the cart checked by the software vendor, it's working like it should, they are pointing to MySQL or Apache and

I''ve got a bunch of records coming back from a database like so ID WORDS 1. banana apple orange 2. apple pear 3. banana orange I want to take the records in the WORDS field and concatinate them into one large array so I can play around with it. How do I do this? -- Posted via http://www.ruby-forum.com/.

I''ve used mysql for quite some time now. Other than crashing when the partition gets full, I''ve had no problems with it. But I''ve heard great things about postgres and have seen some people say it''s much superior to mysql. So, with a Rails application, is there any reason why I would want to learn/use another DB besides mysql? Any pragmatic benefits?

Hi In a controller I have method that is accessed via an AJAX call and will conditionally do: render :nothing => true to test the condition hitting this line I was hoping to do something like: response.should render_template(:nothing) How should I test this behaviour? Cheers Shane

Super, Thanks On Fri, Sep 22, 2017 at 4:57 PM, Boris Steipe <boris.steipe at utoronto.ca> wrote: > > a <- c("<0.1", NA, 0.3, 5, "Nil") > > a > [1] "<0.1" NA "0.3" "5" "Nil" > > > b <- as.numeric(a) > Warning message: > NAs introduced by coercion > > b > [1] NA NA 0.3

myDF <- data.frame(a = c("<0.1", NA, 0.3, 5, "Nil"), b = c("<0.1", 1, 0.3, 5, "Nil"), stringsAsFactors = FALSE) # you can subset the b-column in several ways myDF[ , 2] myDF[ , "b"] myDF$b # using the column, you make a logical vector ! is.na(as.numeric(myDF$b)) # This can be used to select the

I saw from the thread "color output" that there is a plan to "align the runner". Is there a place to see what that means? I am just curious. Thanks Shane

Hi, I have a set of x, y points where x represents dates and y actual values. I am trying to plot a line graph of the data with points on top, but R is connecting the wrong points with lines. Does anyone know how I can rectify this. Please see sample below: x= 24/09/2009 09:13 16/10/2009 11:17 24/10/2009 21:43 11/09/2009 18:34 22/08/2009 15:45 10/08/2009 00:30 14/08/2009 14:52 24/09/2009

Hi, Lets say this was a dataframe where I had two columns a <- c("<0.1", NA, 0.3, 5, "Nil") b <- c("<0.1", 1, 0.3, 5, "Nil") And I just want to remove the rows from the dataframe where there were NAs in the b column, what is the syntax for doing that? Thanks in advance On Fri, Sep 22, 2017 at 5:04 PM, Shane Carey <careyshan at

I want to be able to call an action after performing an edit using the in-place editor macro. I want to update multiple divs so I was thinking about using an RJS template. However, I can''t figure out how to trigger another action after the method created by in_place_edit_for runs. Is there is an option on Ajax.InPlaceEditor where I can inject some Element.update calls? Thanks, Shane

Hello ! I''m trying to run Xen on a EC2 AMI debian-6.0-squeeze-base-x86_64-20110417 (ami-35b68141) Following this how-to http://www.howtoforge.com/paravirtualization-with-xen-4.0-on-debian-squeeze-amd64 After installing the packages, I get : uname -a Linux ip-10-241-22-60 2.6.32-5-xen-amd64 #1 SMP Tue Mar 8 00:01:30 UTC 2011 x86_64 GNU/Linux uname -r 2.6.32-5-xen-amd64 Then I do :

Always via logical expressions. In this case you can use the logical expression myDF$b != "0" to give you a vector of TRUE/FALSE B. > On Sep 25, 2017, at 8:00 AM, Shane Carey <careyshan at gmail.com> wrote: > > This is super, really helpfull. Sorry, one final question, lets say I wanted to remove 0's rather than NAs , what would it be? > > Thanks >

Hello to the list and thanks to Aaron for the cool software. I''ve been fooling around with Mechanize and Hpricot for a couple of days and from the docs I''ve read, the following code SHOULD work but doesn''t. I''ve tried the same code on a couple of different sites and I get the same exception for each. Any pointers or suggestions are appreciated.

I''m evaluating what to use for integration testing: SafariWatir - integrates nicely with RSpec - doesn''t work with Ajax because of Safari event firing issues Selenium - Works with Ajax - doesn''t integrate with RSpec What is the best guess timeframe for RSpec integration testing? Will it be able to test Ajax application in the early iterations? Thanks, Brian Yamabe

This is super, really helpfull. Sorry, one final question, lets say I wanted to remove 0's rather than NAs , what would it be? Thanks On Mon, Sep 25, 2017 at 12:41 PM, Boris Steipe <boris.steipe at utoronto.ca> wrote: > myDF <- data.frame(a = c("<0.1", NA, 0.3, 5, "Nil"), > b = c("<0.1", 1, 0.3, 5, "Nil"), >

I have x, y, z data. The x, y fields dont change but Z does. How do I add a very small number onto the end of each x, y data point. For example: Original (X) Original (Y) Original (Z) 15 20 30 15 20 40 New (X) New (Y)

Hello everyone, I have a problem with smbmount. After I mount a certain share, I can not view files with weird charaters in their name. This happends for example with the copyright char. After searching with Google I still didn't find an answer. I guess it has something to do with a 'charset' command, but I can't figure out wich one, and what character table I should use...

Hi! Can anyone tell me how to convert the anova/ancova summary output into a data frame? Thanks! Shane Phillips [[alternative HTML version deleted]]