Geek asks and answers

Search Engine Optimization in Django Admin

I have a CMS running on Django 1.4 and the database is Postgresql 9.1. I have a lot of content in the CMS, and the problem I am facing right now is that finding Django Admin will always get results. I would like to know if there are options to optimize this Django Admin search behavior. I know that Django uses a LIKE query for Postgresql to do a search. I know that Postgresql 9.1 has a GIN and GIST index that can help speed up this Django behavior. I can also modify this search behavior to make it quick and compromise the quality of the search results a bit. I would like to know the most optimal approach to optimize this behavior in Django?

+5
source share
2 answers

If you do not want to modify Django, do a search and add the appropriate GIN and GIST indexes. Otherwise, you might want to integrate something like Haystack to speed up the search and without being tied to a database.

useful links

http://www.rossp.org/blog/2009/jan/28/django-postgresql-fulltext/

+2
source

You might want to use the Django Debug toolbar to check which SQL queries are actually slow.

We found that the implicit use of Django adminUPPER caused Postgres to ignore all existing indexes. If this is a problem, you can create an uppercase index of your data.

+2
source

More articles:


All Articles