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

From: Simon Flack (sf at flacks.net)
Date: Wed Dec 01 2004 - 23:27:19 GMT


On Tue, 30 Nov 2004 11:27:00 -0800 (PST), Peter Speltz wrote
> --- Brian Glass <brian at 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

_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole



This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:57 GMT