Re: [Connotea-code-devel] feedback

[Kieren D. <ki...@di...>]

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.