id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
18190	slower performance with non-default database + @transaction.commit_manually	assie181@…	nobody	"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

2) Download http://dl.dropbox.com/u/1522424/strange-secondary-DB.tar.gz

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."	Uncategorized	closed	Database layer (models, ORM)	1.3	Normal	invalid			Unreviewed	0	0	0	0	0	0