slower performance with non-default database + @transaction.commit_manually
|Reported by:||assie181@…||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||1.3|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Django exhibits slower performance with non-default database + @transaction.commit_manually compared to default database (with @transaction.commit_manually)
How to reproduce:
1) Install Django 1.3.1 and CherrPy
3) Run as "python cherryserver.py" and observe time values printed.
4) Edit app/statsmanager.py to use "volume_stats.save(using='secondary')".
5) Notice the slow down in saving results to secondary database.
When using real code, saving to default db is taking ~200ms while saving to secondary db is taking > 2 seconds.
(both cases use @transaction.commit_manually).
Either this is a bug in attached test application or it is a bug in Django.