Garrett Garcia wrote:

> I recently got my first django project set up on webfaction and am 
> feeling the constraint of their memory usage limits.
> For example:
> 
> I have a view that returns a list of objects:
> 
> def get_meet_results(request, meet_id):
>     meet = Meet.objects.get(pk=meet_id)
>     year = meet.start.year
>     result_list = Result.objects.filter(meet=meet).order_by('event','score')
>     return render_to_response('meets/meet_results.html', 
> {'year':int(year), 'meet':meet, 'result_list':result_list})
> 
> result_list.count() is about 1500 on average.  In the template, the 
> result list is looped through and a table row is printed for each 
> result.  This renders and loads relatively fast, but uses what seems to 
> me to be a very large amount of memory.

when Django reads an object from a table, it pulls in all the fields. 
if the Result table contains some potentially large fields, you'll pay 
for those even if you're not using them in the template.  you can use 
the "values" method to control this.

also note that some of those 30 megabytes might be modules that are 
pulled by the template (or by some other part of django) when you run 
the view for the first time.  to check that, tweak the query to generate 
only a few hits (e.g. by slicing out the first member).

</F>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" 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/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to