Slow performance with Django when connected to Oracle

Django gurus:

Hello, I am experiencing very slow performance with Django when
connected to an Oracle database. The exact same Django application
runs far faster with PostgreSQL and SQLite, with the same source data
loaded into each database. Looking at the information embedded in
"connection.queries" after making an Oracle query through Django, it
appears that the queries themselves run very quickly (runtimes are
comparable to those measured with PostgreSQL and SQLite), but the
whole turnaround time for a query in Oracle far exceeds the reported
query time.

I've tried the built-in Oracle backend engine and django-oraclepool
0.7; neither improve performance. (With django-oraclepool, I also gave
sufficient time for the connections to pool before taking
measurements). Using cx_Oracle outside of Django on the same
workstation to connect to the same Oracle database, the query
turnaround time is very quick.

Is this problem connected to the fact that Django is reported to drop
the database connection between queries, and therefore must reconnect
to Oracle every time a query is executed? Or is there a Django
configuration option that must be specified to make the best use of
Oracle?

We are using Python 2.7, Django 1.2.1, Oracle 11, and Apache HTTP
Server 2.2.17.

Any help would be greatly appreciated. Thanks!

DW

--
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 django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.