Re: Class::DBI performance issues

[prev] [thread] [next] [Date index for 2004/12/04]

On Sat, Dec 04, 2004 at 06:21:18PM +0000, Tony Bowden wrote:
> 
>   __PACKAGE__->set_sql(track_seconds => q{
>     SELECT SUM(t.duration_in_seconds)
>       FROM __TABLE(=a)__, __TABLE(CD=c)__, __TABLE(Track=t)__
>      WHERE __JOIN(a c t)__
>        AND a.id = ?
>   });
> 
>   sub track_seconds {
>     my $self = shift;
>     $self->sql_track_seconds($self->id);
>   }

Sorry, that should be:

  sub track_seconds { 
    my $self = shift;
    $self->sql_track_seconds->select_val($self->id);
  }

Tony