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

[Matt S Trout]

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/ +