Skip Menu |

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 125758
Status: new
Priority: 0/
Queue: DBIx-Class
People
Owner: Nobody in particular
Requestors: porton [...] narod.ru
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Jul 04 11:48:52 2018 porton [...] narod.ru - Ticket created
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 https://stackoverflow.com/q/51160010/856090: 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)?
  Wed Jul 04 11:50:52 2018 porton [...] narod.ru - Ticket #125759: Ticket created
Subject: Unclear about the difference between join and prefetch
Date: Wed, 4 Jul 2018 18:49:01 +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 https://stackoverflow.com/q/51160010/856090: 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)?
  Wed Jul 04 13:20:42 2018 porton [...] narod.ru - Ticket #125759: Correspondence added
I found that my question is answered in https://metacpan.org/pod/DBIx::Class::ResultSet#prefetch but note that it should be referenced from https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#JOINS-AND-PREFETCHING as otherwise the Cookbook is unclear. On Wed Jul 04 11:50:52 2018, PORTON wrote: Show quoted text
> Documentation bug: Documentation on join and prefetch is not clear. > > From https://stackoverflow.com/q/51160010/856090: > > 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)?
  Thu Jul 12 10:35:57 2018 ribasushi [...] leporine.io - Ticket #125759: Merged into ticket #125758
  Thu Jul 12 10:35:57 2018 ribasushi [...] leporine.io - Merged into ticket #125758