What might be useful is to figure out exactly what SQL Django winds up running then doing an "EXPLAIN <query>" on that query in your DBMS from the command line. That will let you know what the backend is doing and what the performance considerations you should take are.
On Tue, Jan 12, 2010 at 3: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] > > > > > --------------- > > On Jan 12, 8:47 pm, Chris Czub <chris.c...@gmail.com> wrote: > > It really depends on how you're selecting the data from the database. If > > you're doing something that necessitates a full table scan(like in-DB > ORDER > > BY) it will slow you down considerably. If you're selecting one row from > the > > database by an indexed column, then the performance will be very fast and > > there's no need to prematurely optimize. > > > > On Tue, Jan 12, 2010 at 2:25 PM, nameless <xsatelli...@gmail.com> wrote: > > > My table with 4 milions of rows is queried often by ajax. > > > So I think a performance problems ( I am using also index ). > > > Ok now take a look at the contenttypes :) > > > > > ------------ > > > > > On Jan 12, 8:15 pm, Tim <timster...@gmail.com> wrote: > > > > As far as needing to split up the table into other tables, I'm not > > > > sure. Whats wrong with having 4 million records in one table? > > > > > > But if you're going to do it, take a look at the contenttypes > > > > framework and generic relations. It basically does what you're > > > > describing: > > > > > >http://docs.djangoproject.com/en/dev/ref/contrib/contenttypes/#id1 > > > > > -- > > > 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<django-users%2bunsubscr...@googlegroups.com> > <django-users%2bunsubscr...@googlegroups.com<django-users%252bunsubscr...@googlegroups.com> > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/django-users?hl=en. > > > > > > -- > 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<django-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > > >--
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.
