[Dbix-class] Avoiding _prune_unused_joins

Bob MacCallum uncoolbob at gmail.com
Fri May 10 15:46:45 GMT 2013


(I'm using 0.08250)

I'll avoid a boring preamble and just ask if anyone could advise on
how to construct resultsets so that deep in the internals,
_prune_unused_joins isn't called?  (so as to save me some CPU cycles)

I have tried to read the code but I'm not really sure what $ident is holding.

Here's the query that is called most in my code:

  my $rs = $row->some_relation->search(
     {},
     { where => { rank => { '>' => 0 } },
       order_by => 'rank',
       prefetch => { type => { 'dbxref' => 'db' } } }
  );

Performance with the prefetch is slightly better than with no prefetch at all.
Appreciate any help!

many thanks,
Bob.



More information about the DBIx-Class mailing list