[CDBI] performance?

Peter Speltz peterspeltz at gmail.com
Sat Aug 27 18:02:56 BST 2005


Does doing the same thing without class DBI 

On 8/21/05, Josef Chladek <josef at volltext.net> wrote:
> i'm trying to find some 'time' in my program. what i am doing is to
> just retrieve some data for a class (tried it with different classes,
> always the same behaviour)
> 
>          my $tstart = tv_interval($t0);
>          eval {$cdbi = $class->retrieve($id)};
>          my $tend = tv_interval($t0);
>          warn "dt_retrieve ", $tend - $tstart;
> 
> i just loop 10 times over the above code, this results in
> 
> ......start
> dt_retrieve 0.004602
> dt_retrieve 0.004788
> dt_retrieve 0.050046
> dt_retrieve 0.006828
> dt_retrieve 0.004418
> dt_retrieve 0.004669
> dt_retrieve 0.004521
> dt_retrieve 0.014593
> dt_retrieve 0.007402
> dt_retrieve 0.015778
> dt_retrieve 0.017207
> 
> so i have huge differences (order of 10!) for the SAME $id, why? is
> this related to the live_index or can i do something in my program to
> increase the time for retrieving?
> 
> thanks
> josef
> 
> 
> 
> 
> _______________________________________________
> ClassDBI mailing list
> ClassDBI at lists.digitalcraftsmen.net
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
> 


-- 
pjs




More information about the ClassDBI mailing list