[Dbix-class] coercing Result objects

Ben Tilly btilly at gmail.com
Mon Nov 26 16:38:25 GMT 2012


On Mon, Nov 26, 2012 at 1:29 AM, Aaron Trevena <aaron.trevena at gmail.com> wrote:
> On 13 November 2012 14:55, Dave Howorth <dhoworth at mrc-lmb.cam.ac.uk> wrote:
[...]
> This is something I'm looking at myself (search results spanning
> tables via a big union ( DBIx::Class::Helpers has a helper for that
> too btw)

Random tip in case you don't know it.  A union has an implicit dedupe
in it, which is quite expensive.  If ou can, you really want to make
that a UNION ALL instead.

(Database people all know this, developers generally don't.)

Ben



More information about the DBIx-Class mailing list