I have a situation with a model that has multiple relationships to other
models as described below:

Contact (3-4 character fields)
- FK to Organization (3-4 char fields)
- Many to Many to Address (5-6 char fields)
- Many to Many to Phone (3 fields)
- Many to Many to Order

During the checkout process, a person would enter basic contact
information including their address and phone #'s.  When I attempt to
create a new contact (First name, last name, email) and save it, the save
opperation can take several seconds (running the development server with
MySql). Subsequent changes to the contact are quick.  As I add the other
items and associate them to the contact, speed is just fine.  Any other
database updates or changes seem fast enough.  It seems to be localized
saving a new object.  I am not overriding the save function or doing
anything else out of the ordinary.

I'm suspecting I'm doing something wrong in my db design or in my  Django
code.  I believe that the multiple relationships are causing some amount
of extra work during initial creation.

Does anyone have any pointers to ways of improving the time to save a new
object?

Thanks,
Chris



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to