On 9 Aug 2007, at 05:00, Martin Flack wrote: > For the type of thing like Connotea, Class::DBI is way too slow > left to its own devices - a page was taking 800 queries to pull up > all the pieces of data, and we solved that with a scary-looking but > fast-executing query. Another problem might be that it was designed > to be a very flexible query engine, and as it turns out that > flexibility is obscuring some of the functionality, i.e. tightening > the restraints might make prettier source code.
Oops, I should mention that DBIx::Class has much better support for this kind of stuff. It uses SQL::Abstract under the hood which really is an amazing piece of code once you get your head around it. Passing raw sql into DBIC queries involves passing a scalar ref (i.e. \'select foo from bar') into the right part of the Resultset/SQLA code, but there's lots of other customisation available to make custom queries more convenient than this in many cases. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Connotea-code-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/connotea-code-devel
