Sunday, December 19, 2010

query fast on command line - slow via url

I'm trying to determine why our search queries return so slow.

We are not doing anything fancy in our searches, simply searching
for author, or title in a table of about 6000 books.

http://www.rareorientalbooks.com/searchadv/

On the command line using the exact code in the views.py everything
returns instantly.

When accessing the same code via url browser access all searches take
a minimum of 10 seconds whether it returning 10 or 500 titles.

__If via the command line the queries return instantly

* am I right in thinking the bottleneck is somewhere else in the
process?

* where might that bottleneck be and how can i streamline it?

Any ideas appreciated.

--
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.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate