Make joins go fast (Re: [CDBI] Re: Make CDBI go fast)

Bill Moseley moseley at
Thu Feb 15 21:24:02 GMT 2007

On Thu, Feb 15, 2007 at 11:56:36AM -0500, Michael G Schwern wrote:
> Edward J. Sabol wrote:
> >> * Somehow make joins go fast
> > [...]
> >> * Construct a hierarchy of CDBI objects from a SELECT
> > 
> > These features would be very welcome, I'm sure, but I fear they will prove
> > difficult or hack-ish to implement and maintain (c.f. CDBI::Sweet).
> Tell me about how CDBI::Sweet handles joins.  Can I use it as a drop in replacement for CDBI?

It's not a replacement.  I can't explain as well as the CDBI::Sweet
docs, but it adds in features that you really want to use in a typical
web application -- paging, counting, sorting by columns in joined tables,
selects that automatically create joins, using aggregates, etc.

Bill Moseley
moseley at

More information about the ClassDBI mailing list