[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