Re: [CDBI] How do you get the raw db value of a column rather than inflated object

[prev] [thread] [next] [Date index for 2006/02/11]

From: Michael Peters
Subject: Re: [CDBI] How do you get the raw db value of a column rather than inflated object
Date: 18:26 on 11 Feb 2006

Bill Moseley wrote:
> On Sat, Feb 11, 2006 at 12:56:05PM -0500, Michael Peters wrote:
> 
>>>    $object->my_column->id
>>
>>The downside to this approach is that if you just want the id (which you already
>> know since it's a column in $object's table) you can't juse use it. You have to
>>create a second object (which may require a trip to the database). In a tight
>>loop, this could cause some performance problems.
> 
> 
> If it's already known (i.e. the column was fetched when $object was
> created) then there's no extra trip to the database.  Just an extra
> method call.

Well, it depends on which columns you have marked as essential. So for the
column to be fetched when $object is created, you need it in $objet's list of
essential columns, but you can't be as liberal with "column"s essential columns
or it will cost you another trip.

        -- 
        Michael Peters
Developer
Plus Three, LP


_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

(message missing)

Re: [CDBI] How do you get the raw db value of a column rather than inflated object
Michael Peters 18:26 on 11 Feb 2006

Generated at 10:41 on 18 Feb 2006 by mariachi v0.52