[Dbix-class] Excluding columns from a query
Nick Wellnhofer
wellnhofer at aevum.de
Mon Feb 15 22:08:45 GMT 2010
On 15/02/10 18:01, Robert Sedlacek wrote:
> 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.
Yes, I thought about that. It's probably what I'm going to do.
Nick
More information about the DBIx-Class
mailing list