On 2/26/14 2:41 PM, Shawn H wrote:
Because this worked so well, I've gone directly to cx_Oracle in my
django view and used that to get the result in the 4 seconds. There
is definitely a problem with the Django implementation - I wonder if
perhaps the indexes on the tables aren't being used properly.
That would seem unlikely since you are specifying the query directly.
If you suspect that Django *is* modifying your query, can you look at
the query as it arrives to the Oracle backend and compare the two test
cases?
hth
- Tom
On Wednesday, February 26, 2014 3:49:47 PM UTC-6, Shawn H wrote:
3.8 seconds. It seems to be django, not cx_Oracle.
On Wednesday, February 26, 2014 2:50:58 PM UTC-6, Shawn H wrote:
Good idea. I'll try that and report back
On Wednesday, February 26, 2014 1:22:52 PM UTC-6, Tom Evans
wrote:
On Wed, Feb 26, 2014 at 6:16 PM, Shawn H
<shawn....@gmail.com> wrote:
> Yes. I've tested with several case numbers, and I'm
using a similar
> parameterized approach in my gui Oracle client as well,
with the same
> results. It's always about 3 to 4 times slower running
via django. I've
> tried it both on my local development web server as well
as my production
> apache linux box, and it always takes much longer
running via django.
>
>
If you write a standard python program, ie not using
django, but still
using whatever oracle DB adapter Django uses, that
connects to your
oracle server and executes the query, is it still slow?
IE is the problem something django does, or how the
adapter works.
Cheers
Tom
--
You received this message because you are subscribed to the Google
Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/c4ff4ee0-43b8-4d1f-9ef0-6ef93546dcad%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/530E7179.4000306%40gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
