If you're running MySQL w/InnoDB (instead of MyISAM), then deferring
transaction COMMITs until after your data has loaded (instead of after
each INSERT, as what happens by default with `save`) should yield
significant time savings.  This may be accomplished by simply using
the `commit_on_success` decorator -- and it doesn't require modifying
Django's internals, or writing custom SQL, as others have suggested.

from django.db import transaction
from myapp import MyModel

@transaction.commit_on_success
def load_my_data():
    for foo in bar:
         m = MyModel(foo=foo)
         m.save()
--~--~---------~--~----~------------~-------~--~----~
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