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 [email protected].
To post to this group, send email to [email protected].
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.
