Re: [Rails] sql performance

On 01/16/2013 02:04 PM, Dave Aronson wrote:
> 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
>
I don't think so. The CACHE entries mean that the op did the same fetch
as he had recently done and the data was still around and was used with
no db access.

Norm

--
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.