[Dbix-class] DBIx::Class or Rose::DB::Object or other???
Matt S Trout
dbix-class at trout.me.uk
Mon Jun 19 14:42:39 CEST 2006
Jesper Krogh 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.
It's a pain. It is, however, a great improvement over taking the hit
constantly at runtime which is what we had with NEXT.
I have some tentative ideas for improving the startup time, but nothing
concrete yet. Maybe by 1.0 :)
Matt S Trout Offering custom development, consultancy and support
Technical Director contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information
+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +
More information about the Dbix-class