Re: Terrible performance when dropping into raw SQL Oracle

Is the case number the same when you run the query in SqlPlus as when you run it in Django? In other words, are you certain the query is exactly the same?

_Nik

On 2/25/2014 2:09 PM, Shawn H wrote:

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+unsubscribe@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.