[Dbix-class] DBIx::Class or Rose::DB::Object or other???

Guillermo Roditi groditi at gmail.com
Mon Jun 19 13:48:38 CEST 2006


To be fair, RDBO has a nasty load time as well. If you really really need
fast loading from perlscripts then you might as well just use plain vanilla
DBI

On 6/19/06, Jesper Krogh <jesper at krogh.cc> wrote:
>
> Matt S Trout wrote:
> >> 1. RDBO is faster.
> >> 2. DBIC has a Class::DBI compatibility layer that will make the
> >> transition from CDBI easier
> >
> > RDBO is much faster on the perl side; in a majority of situations you
> > can generate SQL that's just as efficient on the database using DBIC
> > (certainly for selects, which in most apps is likely to be the majority
> > of the database load - although RDBO supports prefetching of multiple
> > one-many relations at once at the same level, which DBIC doesn't as
> yet).
>
> Loading time..  The usage of Class::C3 / Algorithm::C3 in DBIx::Class,
> scales quite bad. In a setup with > 30 tables, the load time for the
> modules in DBIx::Class is more than 2 seconds. (not using the loader or
> anything). (measured on a decent Opteron server)
>
> In Catalyst.. I would say "it doesn't matter" but if you're using the
> ORM from perlscripts too, then this is a quite big overhead.
>
>
> Jesper
>
> --
> Jesper Krogh, jesper at krogh.cc
>
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
> http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060619/580d9cb0/attachment.htm 


More information about the Dbix-class mailing list