-- View this message in context: http://www.nabble.com/survey-tp14497860p14497860.html Sent from the RubyOnRails Users mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
hi all, sorry for the previous blank post...it was posted accidently... I have to publish an online survey form which will target a global audience. I want to incorporate dynamic analysis of the survey results...in other words I should be able to interpret the feedback whenever necessary. The form has been created using the Rails helper methods - I need tips on how to analyse the database entries efficiently. Any alternate/ more efficient solution would also be welcome. Thanks, Sandip -- View this message in context: http://www.nabble.com/survey-tp14497884p14497884.html Sent from the RubyOnRails Users mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Quoting sandipfloyd <sandipfloyd-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:> > > hi all, > sorry for the previous blank post...it was posted accidently... > > I have to publish an online survey form which will target a global audience. > I want to incorporate dynamic analysis of the survey results...in other > words I should be able to interpret the feedback whenever necessary. The > form has been created using the Rails helper methods - I need tips on how to > analyse the database entries efficiently. Any alternate/ more efficient > solution would also be welcome. >Since no details of the kinds of analysis are provided, it is rather hard to give specific advice. Since the data is in a database, any programming language or statistical package with an interface/API to the database can do something. You could do the analysis in Ruby, SQL, C/C++, etc. Whatever is comfortable. Jeffrey --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Jeffrey L. Taylor wrote:> Quoting sandipfloyd <sandipfloyd-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>: >> solution would also be welcome. >>do i get bonus bucks for this???? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Dec 25, 4:23 pm, sandipfloyd <sandipfl...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I have to publish an online survey form which will target a global audience. > I want to incorporate dynamic analysis of the survey results...in other > words I should be able to interpret the feedback whenever necessary. The > form has been created using the Rails helper methods - I need tips on how to > analyse the database entries efficiently. Any alternate/ more efficient > solution would also be welcome.How many surveys do you expect to be analyzing (absolute maximum) and how many fields are there per survey? Also, what types of analysis need to be done? Reason I ask: Ruby is not designed for efficient execution, it''s designed for efficient development. One tip I can give you straight off: don''t use SQLite (default for Rails 2), it''s very inefficient especially when indexes are needed. Use MySQL. Another issue for efficiency in data analysis: Rails has no way to specify types of indexes with add_index in migrations. add_index simply uses whatever the default index is in that particular database which is normally a hash -- good for unique lookups, bad for range lookups. You''ll need to set all indexes that require range lookups manually in the database to tree indexes. (I am in the process of creating and recommending a patch to add index type selection to the add_index method) -- Travis --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---