How much caching is DBIC doing under its own hood? If we execute the same complex query several times, is any attempt made to save the internal state of how DBIC arraived at the SQL from the DBIC/SQLA method calls?
Likewise on the back end? Just throwing ideas out, but along the same vein as Moose's make_immutable, if we could signal to DBIC that a query/resultset is not going to change but for it's bind values, we'd be able to get the developers' advantage of the ORM, and the runtime advantage of reusing prepared statements. Or does that already exist, and I require some book learning? Also, I infer form the docs (as I think Laurent may have) that there is significant overhead in instantiating row objects, and that hashref inflator would provide *significant* (emphasis mine) speed imrovements over objects. Len. -- lenja...@jaffesystems.com 614-404-4214 www.volunteerable.net Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, Grub Asst: 2008, Trained: 2007.
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk