When calling bulk_create() using django-pyodbc backend, an insert statement is run for each object in the batch. The behavior should be to run a single insert statement per batch.
Is this a bug, or is there a way to alter this behavior?
Versions:
I'm betting the version of django-pyodbc you're using doesn't support bulk insert. I would recommend using django-pyodbc-azure, which you can install with:
pip install django-pyodbc-azure<1.8
django-pyodbc-azure matches it's version numbers to Django's, so you'll want the latest / greatest version from the 1.7 branch (thus, <1.8).
It should support bulk_insert():
I'd also recommend upgrading to Django 1.8 (long term support) or 1.10 (current release), as security patches and bug fixes are no longer being issued for 1.7. Good luck!