On Wed, Jun 20, 2012 at 1:49 PM, Len Jaffe <lenja...@jaffesystems.com>wrote:
> > > On Wed, Jun 20, 2012 at 2:39 PM, Bill Moseley <mose...@hank.org> wrote: > >> >> I'd worry less about where your database calls are happening. Do you >> really care if [% user.address.city | html %] hits the database in the >> template or in the controller? >> > Well, not caring where this happens tends to lead to the what you describe > next. Why not put the address data in the stash? The model knows it will > need to display it. > A bit off the topic here. There's no perfect solution. I've unwound loops in Controllers, too. > > >> One point of the object abstraction is you don't care about the >> implementation. The real problem I've seen, though, is doing something >> stupid like huge nested loops in the template where each one generates a >> query. >> > This is what I meant to about maintenance nightmare. > > I've inherited apps like this where I had to roll nested queries (in > templates) up into a single query to go from 120 round-trips to the > database, taking 8 seconds, into one round trip, taking half a second. > > L. > > > -- > lenja...@jaffesystems.com 614-404-4214 www.volunteerable.net > Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage > Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, Grub > Asst: 2008, Trained: 2007. > > > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: > http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk > -- Bill Moseley mose...@hank.org
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk