Ben Tilly wrote: > On Mon, Nov 26, 2012 at 1:29 AM, Aaron Trevena <aaron.trev...@gmail.com> > wrote: >> On 13 November 2012 14:55, Dave Howorth <dhowo...@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 _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk