I think you have the same problem that I had -> too many queries to
the datastore.
I'm pretty sure that {{profile.user.email}} and similar are giving you
too many queries, because do not have joins.
I assume that in profile the user is a ReferenceProperty.
You fetch 100 profiles -> 1 query
Getting user for those 100 profiles -> 100 queries
GAE is cahcing the ReferenceProperty AFAIK. If it wouldn't be the
case, you could get even 500 queries.
You need to redesing this loop, propable getting profiles and then
getting all users with another, but one query.
--
Rafal Jonca
Blog: http://www.rafaljonca.org/
On 18 Lis, 09:56, Bigdude <[EMAIL PROTECTED]> wrote:
> Google app engine tells me to optimize this code. Anybody any ideas
> what I could do?
>
> def index(request):
> user = users.get_current_user()
> return base.views.render('XXX.html',
> dict(profiles=Profile.gql("").fetch(limit=100),
> user=user))
>
> And later in the template I do:
>
> {% for profile in profiles %}
> <a href="/profile/{{profile.user.email}}/"><img
> src="{{profile.gravatarUrl}}"></a>
> <a href="/profile/{{profile.user.email}}/">
> {{ profile.user.nickname }}</a>
> <br/>{{ profile.shortDisplay }}
>
> Where the methods used are:
>
> def shortDisplay(self):
> return "%s/day; %s/week; %s days" % (self.maxPerDay,
> self.maxPerWeek, self.days)
>
> def gravatarUrl(self):
> email = self.user.email().lower()
> default = "..."
> gravatar_url = "http://www.gravatar.com/avatar.php?";
> gravatar_url += urllib.urlencode({'gravatar_id':hashlib.md5
> (email).hexdigest(),
> 'default':default, 'size':"64"})
> return gravatar_url
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
