http://www.djangoproject.com/documentation/db-api/#select-related
On Dec 11, 1:18 pm, Joe <[EMAIL PROTECTED]> wrote: > I've found the largest memory hog to be the native way related tables > are setup. > > Check class definitions with related tables and edit as such: > > class ...(models.Mode): > relatedtable = models.ForeignKey(RelatedTable, core=True, > raw_id_admin=True) > > The raw_id_admin=True prevents django from pulling up all related > records when the object is loaded etc. While I would have expected > this to only affect the admin side, it had a huge impact on the public > side of our site. Memory consumption went from +500mb to 20-30mb. > > Joe > > On Dec 11, 12:53 pm, Richard Coleman <[EMAIL PROTECTED]> > wrote: > > > At work, we are developing a commercial website based on Django. It's a > > fairly dynamic site (think social networking). I am doing the initial > > load testing to estimate the number of servers we will need for the > > production site. The production site will be load balanced using a pair > > of BigIP boxes. > > > When I stress test the dynamic part of the site, I am only getting about > > 300 requests per second on my test setup. This is using two Dell 1950's > > (one for web, one for mysql database). These are very powerful machines > > (3.0ghz Xeons, 8 cores each, 16 gig of ram, 15k SAS drives, etc.) > > > I've done all the standard performance tuning I find when reading > > through various websites about django tuning. Is this the performance I > > should expect. > > > When I'm running the load test, the CPU on the web server gets > > completely buried (even with 8 cores). The mysql server doesn't seem > > loaded at all. Any suggestions on how to find the bottlenecks? > > > I'm running Ubuntu 7.10 (server, 64 bit version). Django from a very > > recent trunk. > > > Thanks for any advice. > > > Richard Coleman > > [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
