Hi Nameless, On Jan 12, 9:20 pm, nameless <xsatelli...@gmail.com> wrote: > The table is queried from ajax using an autocomplete field with this > query in the views.py: > > books.objects.filter(book_title__istartswith=request.GET['q'])[:100]
This should not be a problem in MySQL either if you are using an index for the string field. MySQL string indices creates a tree with the first letter as the top node, which means your lookup will be extremely fast when using an iindex. As someone else said, using memcache or similar on top of that should make the search fast enough. That said, the size of a table is rarely the problem. It is rather how you choose you indices and what to cache. Jens
-- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
