Thanks Marcin. I will try your ideas.
--- On Mon 06/04, [EMAIL PROTECTED] < [EMAIL PROTECTED] > wrote: From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] To: django-users@googlegroups.com Date: Mon, 04 Jun 2007 09:09:30 -0700 Subject: Re: Big app, big db, all users are authenticated Hi,On Jun 4, 3:48 pm, "and_ltsk" <[EMAIL PROTECTED]> wrote:> 1. 100MB per request - is it normal?not likely. I have apache processes serving a couple of differentsites within separate python interpreters and they are all somewherein the 10-30MB memory range.Common gotcha: make sure you have DEBUG set to False, otherwise Djangostores all executed SQL queries in memory.> 2. I can't use cache because one user receives cached response for another user. Did you know any solution for authenticated cache?You can set up caching per-session, look for "vary_on_headers" and"Cookie" in the cache documentation. But that greatly increases thecache size, of course.I prefer to cache template fragments, see http://code.djangoproject.com/ticket/1065-- this way the parts that don't depend on logged-in user can becached only once for the whole site and I still can cache fragmentsper-session.> 3. While any table growing, the responses became slower to 2-10 minutes. How to avoid the big dicts or use another another solution?Make sure you have indexes in the database. Also, check yourtemplates and code for "if big_queryset" instead of "ifbig_queryset.count" -- the former pulls all the data from thequeryset, the latter does not.> For any performance tip thanks in advance.Point 3. looks like a hint there is something wrong with the way youpull data from the database. Look into the queries, perhaps there isa large number of them or some of the queries download too much data.-mk _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
