[Dbix-class] Excluding columns from a query

Robert Sedlacek rs at 474.at
Mon Feb 15 17:01:54 GMT 2010


Hey Nick,

Nick Wellnhofer wrote:
> It's simply an optimization. I have a table with a text column that can
> contain tens of KB of data per row. I also have some queries that don't
> need that column, so I'd like to avoid unnecessarily fetching all that
> content from the DB.

Depending on the queries you need to perform you might get away with
separating the larger content out into a separate result source that you
prefetch only when required.

regards,
-- 
Robert 'phaylon' Sedlacek

Perl 5 Consultant for
Shadowcat Systems Limited - http://shadowcat.co.uk/



More information about the DBIx-Class mailing list