Hi. I'm having performance problems with Django under mod_python on my beta server. I've installed my application on a shared (virtual) server, running Suse Linux 9.3, with apache2, mod_python and PostgreSQL. The server is supposed to offer 384MB RAM and is a shared dual-core Itanium 2.6GHz machine. The Django application runs, but is really sluggish. When I request a page, "top" shows several httpd2 processes eating up 30% CPU time each, going back down to roughly 0% when the request is competed. Requests for static (media) files are OK.
I *think* I've narrowed my problem down to DB backend performance. I've written a simple "print hallo" Python script, whcih executes almost instantaneously. This script, though: - - - - - print "Programm startet." from django.models.models import submissions print submissions.get_list() - - - - - Prints "Programm startet" almost immediately, then shows the results of the get_list (a mere 2 objects) anywhere between three and seven seconds later !!! I've also written a simple "hello world" Django page, which also returns very quickly, so the problem is probably not directly related to mod_python and apache2. I conpiled and installed psycopg-1.1.21 from the sources -- is there anything I could have done wrong here, which now gives me this performance hit? Is Django doing database connection pooling, or is there a way to tell it to? Can anybody point me at good performance tuning tips for this kind of a setup? Maybe there are some Postgres settings I can fiddle with? I'd hate to let beta users access the site if it'll be this slow (I'll have to move to a *real* server as a last resort -- Django is blazingly fast on my development machine). Any tips greatly appreciated. Daniel --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
