[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