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

From: Peter Speltz (peterspeltz at yahoo.com)
Date: Tue Nov 30 2004 - 19:27:00 GMT


--- 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

=====
pjs

                
__________________________________
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com

_______________________________________________
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