[TurboGears] Re: Widgets and performance

[Matthew Bevan]

Woh... you're pulling data, then pulling more data based on the previous data in the -template-? Try splitting out that logic into the controller method. I avoid pulling new data in my templates like the plague -- it's only a side note that requesting specific columns for some of my objects fires off additional SQL queries.

On 19-May-07, at 9:31 AM, kerinin wrote:

Thanks, that may help.  Part of my problem may be that my data model
is highly interconnected, and a lot of my templates require pulling
large amounts of data from the database, and then using that
information to pull more information out.  I'm going to try caching
some of my classes and rewriting the templates in cheetah - I'll post
an update when I've tried that.

Matthew Bevan, Systems Administrator
Top Floor Computer Systems Ltd.

smime.p7s
Description: S/MIME cryptographic signature