I have a page where about 500 records are displayed, or should be displayed but I have observed that when I limit records around 50 only, servers start getting hiccups and showing message that ''Something went wrong'' and blah blah. But when I am limiting records to 30, it works smoothly. Please tell me what to do. Do I need a large bucked (data type) to put records in? Or do I need to modify something at server side? I am using Mongrel. Thanks -- 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 -~----------~----~----~----~------~----~------~--~---
Hi Vapor May I suggest that you look at ActiveScaffold. Using AS, I am displaying for one table with 40,000 records displaying 15 records (configurable) per page speedily and with no issues. CCH http://cch4rails.blogspot.com On Oct 31, 7:05 pm, "Vapor .." <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> I have a page where about 500 records are displayed, or should be > displayed but I have observed that when I limit records around 50 only, > servers start getting hiccups and showing message that ''Something went > wrong'' and blah blah. But when I am limiting records to 30, it works > smoothly. > > Please tell me what to do. Do I need a large bucked (data type) to put > records in? Or do I need to modify something at server side? > > I am using Mongrel. > > Thanks > -- > Posted viahttp://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 -~----------~----~----~----~------~----~------~--~---
Yes with with ActiveScaffold, I had two tables, one with 48000 records, and another with 175000. Both development and production was no problem. (I was using Oracle 10g and XE for database) Also be careful of funny fieldnames in your tables that happen to be reserved words to your database, I got caught on this one. On Oct 31, 8:02 pm, CCH <c...-Z/Eug3sLCsSPzdAsCNHSEg@public.gmane.org> wrote:> Hi Vapor > > May I suggest that you look at ActiveScaffold. > Using AS, I am displaying for one table with 40,000 records displaying > 15 records (configurable) per page speedily and with no issues. > > CCHhttp://cch4rails.blogspot.com > > On Oct 31, 7:05 pm, "Vapor .." <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > wrote: > > > > > I have a page where about 500 records are displayed, or should be > > displayed but I have observed that when I limit records around 50 only, > > servers start getting hiccups and showing message that ''Something went > > wrong'' and blah blah. But when I am limiting records to 30, it works > > smoothly. > > > Please tell me what to do. Do I need a large bucked (data type) to put > > records in? Or do I need to modify something at server side? > > > I am using Mongrel. > > > Thanks > > -- > > Posted viahttp://www.ruby-forum.com/.- Hide quoted text - > > - Show quoted text ---~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
could you guys help me with some code..my current is in controller ... @product= Product.find(:all, :conditions => [''owner_id = ?'', session[:user].id], :order => ''time DESC'', :limit => 40) how do I get list in @product variable with ActiveScaffold ? -- 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 31 Oct 2007, at 11:05, Vapor .. wrote:> > I have a page where about 500 records are displayed, or should be > displayed but I have observed that when I limit records around 50 > only, > servers start getting hiccups and showing message that ''Something went > wrong'' and blah blah. But when I am limiting records to 30, it works > smoothly. > > Please tell me what to do. Do I need a large bucked (data type) to put > records in? Or do I need to modify something at server side?That ''blah blah'' probably tells you what went wrong. Without the details of what errors you''re getting it will be hard to suggest a fix. Fred --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
> That ''blah blah'' probably tells you what went wrong. Without the > details of what errors you''re getting it will be hard to suggest a fix. > > Fred:) that blah blah is that ''we have been notified of this issue'' and there''s Error 500 Internal Server Error on top -- 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 31 Oct 2007, at 15:54, Vapor .. wrote:> >> That ''blah blah'' probably tells you what went wrong. Without the >> details of what errors you''re getting it will be hard to suggest a >> fix. >> >> Fred > > :) that blah blah is that ''we have been notified of this issue'' > and there''s Error 500 Internal Server Error on topFix your configuration so that you get the actual exception been through with stack trace etc... and you''ll find problems a lot easier to fix (config.action_controller.consider_all_requests_local in development.rb, production.rb etc... do this) Fred
> Fix your configuration so that you get the actual exception been > through with stack trace etc... and you''ll find problems a lot easier > to fix (config.action_controller.consider_all_requests_local in > development.rb, production.rb etc... do this) > > FredI checked the logs and it says ''Lost connection to the MySQL server''. But if I limit records to 30, it never happens and works fine. It seems that problem is with MySQL when I get slightly large amount of data out of it :/ -- 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 -~----------~----~----~----~------~----~------~--~---