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