I've an app that has to drop into raw sql to run a query in a different
Oracle database. The ORM isn't involved as I'm trying to get a count of
rows that meet specific criteria to return that count via an AJAX call.
Running the identical query in SqlPlus takes ~4 seconds. Django takes ~16
seconds. What might be the problem? My view function is below. The 16
seconds is between cursor.execute and the if number_count[0][0] lines.
Thanks in advance for the help.
def get_number_of_notices(request, case_number):
from django.db import connections
try:
cursor = connections['landmgm'].cursor()
cursor.execute('SELECT count(1) from (SELECT DISTINCT RECORDNUMB FROM
NOTICED_PARCELS WHERE CASE_NUMBER = %s AND RECORDNUMB > 0 UNION \
SELECT DISTINCT RECORDNUMB FROM CONDONOTICE WHERE CASE_NUMBER = %s AND
RECORDNUMB > 0)', [case_number, case_number])
number_count = cursor.fetchone()
if number_count[0][0] <= 0:
msg = json.dumps('{"msg":"Notification has not been run for this case",
"number_notified":"0", "result":"Fail"}')
return HttpResponse(msg, content_type='application/json')
else:
msg = json.dumps('{"msg":"Notification has been run for this case",
"number_notified":"' + str(number_count[0][0]) + '", "result":"Success"}')
return HttpResponse(msg, content_type='application/json')
except:
msg = json.dumps('{"msg":"An error was encountered while checking this case
number. Please contact GIS Staff.", "result":"Error"}')
return HttpResponse(msg, content_type='application/json')
--
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/9aeb979c-4cce-4525-b813-2a35558cc62b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
