[Dbix-class] Performance Issue

Peter Rabbitson rabbit+dbic at rabbit.us
Tue Feb 21 14:53:24 GMT 2012


On Mon, Feb 20, 2012 at 04:04:13PM -0600, Bill McCormick wrote:
> I added some metrics. There is a HUGE (~1.5 sec) difference that needs  
> to be accounted for here. Either I'm doing something very wrong (very  
> likely) or there is something very wrong with DBIx.
>
> Each test starts with this:
> BEGIN {
>     print qq/***** Start Test *****\n/;
>     $start = clock();
>     print qq/Start: $start\n/;
> }
>
> The part that takes the longest is loading the DBIx::Schema compared to  
> loading DBI & DBD, but even the DB connect an query takes longer.

<snip>

>
> $:/home/fiber/www/cgi-bin# ./recipe-test-DBIx.pl;./recipe-test-DBI.pl
> ***** Start Test *****
> Start: 0.08
^^ ok

> Load Use: 1.12
^^ this depending on the size of your schema may be normal or may not be

> Connect: 1.32
> Query: 1.65
> Complete: 1.66
^^ diagnosing the rest without your actual schema is impossible

See my next email



More information about the DBIx-Class mailing list