I had a fruitless discussion with a fellow coder today. Summarily, we have a model for students that will keep growing with time. I mean to say the number of records in the database will keep growing, and no rows are going to be deleted.
Now, students fall in one category or the other, and this is marked by a BooleanField. We are using MySQL. Is it advisable to index that BooleanField (that is db_index = True in Django)? All queries on the model will 'almost always' include a check on that BooleanField, that is Student.object.filter(categorized=False) or Student.object.filter (categorized=True) I have spent a lot of time on the MySQL forums to find out an answer to this, but am as lost as before. Some even said an index on a Boolean in such a case would degrade performance. -- 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.
