|Subject:||Unclear about the difference between join and prefetch|
|Date:||Wed, 4 Jul 2018 18:47:06 +0300|
|To:||bug-DBIx-Class [...] rt.cpan.org|
|From:||Victor Porton <porton [...] narod.ru>|
Documentation bug: Documentation on join and prefetch is not clear. From: Please explain in details the difference between join and prefetch in DBIx::Class. joins maps to JOIN in SQL, right? prefetch makes to read all data from related tables, right? But it seems for me that in the case of a has_a relationship to a table, joining and prefetching this table do exactly the same thing, add an SQL JOIN. Right? Is there any difference between join and prefetch for has_a relationships? So when to use either (especially for has_a relationships)?