Large amount of records brings error

Rails
1

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

2

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

On Oct 31, 7:05 pm, “Vapor …” [email protected]

3

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.

4

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 ?

5

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

:slight_smile: that blah blah is that ‘we have been notified of this issue’
and there’s Error 500 Internal Server Error on top

6

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

:slight_smile: that blah blah is that ‘we have been notified of this issue’
and there’s Error 500 Internal Server Error on top

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)

Fred

7

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)

Fred

I 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 :confused:

8

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