[Dbix-class] coercing Result objects

[Dave Howorth]

Ben Tilly wrote:
> 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.)

Ooh, shiny! Thanks, I didn't know that.

Cheers, Dave