Re: Make joins go fast (Re: [CDBI] Re: Make CDBI go fast)
Bill Moseley <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected]