On 6/19/06,
Jesper Krogh <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED]
_______________________________________________
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/[email protected]/
_______________________________________________ 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/[email protected]/
