Wednesday, January 16, 2013

Re: [Rails] sql performance

On Tue, Jan 15, 2013 at 5:25 AM, Werner <webagentur.laude@googlemail.com> wrote:

> Form entries are stored but on reload it gives me tons of:
> CACHE (0.0ms) SELECT `hours`.* FROM `hours` WHERE `hours`.`id` = 189
> LIMIT 1

That sounds like you could benefit from a .includes on your initial
load. Google "N + 1 queries problem".

-Dave

--
Dave Aronson, the T. Rex of Codosaurus LLC,
secret-cleared freelance software developer
taking contracts in or near NoVa or remote.
See information at http://www.Codosaur.us/.

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate