Login

Adding data in a transaction

Author:
hughdbrown
Posted:
July 20, 2009
Language:
Python
Version:
1.0
Tags:
django transaction etl
Score:
-2 (after 2 ratings)

Place a database transaction around creation of a lot of data. Substantially increases insertion speed.

1
2
3
4
5
6
7
8
9
from django.db import transaction

@transaction.commit_manually
def viewfunc(request):
    ...
    for item in items:
        entry = Entry(a1=item.a1, a2=item.a2)
        entry.save()
    transaction.commit()

More like this

  1. Accepting and processing PayPal IPN messages (including using App Engine) by simon 6 years, 6 months ago
  2. Commit on success unless managed decorator by Kronuz 5 years, 5 months ago
  3. Nested commit_on_success by rfk 6 years ago
  4. Username filled automatically with id by djangoman 5 years, 1 month ago
  5. nested transactions context manager and decorator by demanzano 3 years, 6 months ago

Comments

Please login first before commenting.