[Maypole] Re: Maypole responding to requests very slowly (or, how to get just one associated record instead of getting the world)

[Simon Flack]

On Tue, 30 Nov 2004 11:27:00 -0800 (PST), Peter Speltz wrote
> --- Brian Glass <brian@glassbrian.com> wrote:
> 
> > Simon Flack wrote:
> > 
> > >Forgive me if I'm barking up the wrong tree here, but isn't this a
> > >Class::DBI::AsForm issue? I seem to remember suggestions that setting the
> > >Essentials columns appropriately in your CDBI classes would give significant
> > >performance improvements. Have you tried that, and if so, did it help?
> > >
> > >I was also under the impression that the default templates were just
> > examples:
> > >    http://lists.netthink.co.uk/pipermail/maypole/2004-November/000975.html
> > >
> > >I'd like to see them stay that way and not over-complicate them. If there is
> > a
> > >demand for drop-in templates, I suggest creating Maypole separate "theme
> > packs".
> > >
> > >--simonflk
> > >
> > 
> > Yes it is (an AsForm issue that is). The suggestion to set Essential 
> > columns does indeed help performance - and quite a bit too. But it's 
> > still not enough. When you get back a result set of 3000 rows and 
> > proceed to convert that all to Class::DBI objects and then turn right 
> > around and convert them all to HTML::Element objects, and then convert 
> > them all to HTML it tends to slow things down a bit.
> >
> 
> I started a mapole wiki cookbook page where hopefully we can cook up 
> good solutions to AsForm issues.  Maybe it'd be better off in CDBI 
> wiki eventually but more maypole users seem to be concerned with it. 
> For starters i just outlined problems we are having.
> 
> http://maypole.perl.org/?ImprovedAsForm

That's very useful. FWIW, I'm planning on spending some time on
CDBI::Plugin::Type soon after the next Maypole release. In the meantime,
patches are welcome. Actually, I may upload a new version soon just to update
the contact information.

I can't speak for CDBI::AsForm since that's now maintained by someone else. I
think Tony Bowden has taken over. It's probably worth sending a courtesy email
that points to that wiki page/this thread in case he misses it.

--simonflk