Frederick Cheung wrote:
> On Aug 24, 3:12�pm, Aldric Giacomoni <rails-mailing-l...@andreas-
> s.net> wrote:
>> > Rails to commit / process the transaction so it happens in a better type
>> > of real-time than that?
>
> Well database transactions are supposed to be like that - once you've
> sent "commit" then it's on disk (and if you're not in a transaction
> then every statement is surrounded in an implicit transaction). Are
> you sure that it isn't just buffering on the log file that is fooling
> you ?
>
> Fred
Well, when I try to view the report, I get one of two behaviors. Ignore
the lack of 'a', it's a bug with the console I use (yay Windows).
1) It loads almost instantly. Log file shows:
Processing ReportsController#folder (for 127.0.0.1 t 2009-08-24
11:28:02) [POST]
Prmeters: {"folder_id"=>"1",
"uthenticity_token"=>"3WKJGViOKytwH7Xn+g8Q1d4rH5xu9Q1H03tkqo4+pI="}
Report Lod (47.0ms) SELECT * FROM "reports" WHERE
("reports"."report_pth_id" = '1')
Rendered reports/_lists (124.0ms)
Rendered reports/_lists (0.0ms)
Rendered reports/_lists (0.0ms)
Rendered reports/_folder (124.0ms)
Completed in 218ms (View: 124, DB: 47) | 200 OK
[http://loclhost/reports/folder?folder_id=1]
2) It takes longer than 'instantly'. Sometimes considerably longer.
I get the same output than in 1 but, prior to that, I get a ton of
'select' and 'update' statements... The same statements which should be
happening during the background job I have that runs every 5 minutes.
That background job outputs to the log file "#{Timestamp} - Swept for
reports." and the issue happens after I see this a couple of times with
no other activity.
When I came back from the week-end, as I was saying, I saw it do a whole
lot of time updates, every 5 minutes, on the same db entries.. When I
expect that these should have been done, you know, when the job ran!
I don't understand why it would buffer so much select/update statement
that should go out to the log, and why that'd slow down the app
anyway... Any idea?
--
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
