On Fri, Feb 19, 2010 at 2:48 AM, Timothy Kinney <timothyjkin...@gmail.com> wrote: > What does it mean to check about index selectivity? Sorry, my knowledge of > databases is mostly as a user. But I am learning a lot this week.
I intentionally left it out, since i'm not the best teacher, you might not need it (if you choose the CommaSeparatedIntegerField (i forgot it's already there!)), it's not the easiest concept of relational databases to grasp, and it's getting a little off topic. put shortly: if you have a table with lots of records (many thousands, maybe millions) with a non-unique index that has very few different values, any insert to the table would be seriously degraded. Check this case on StackOverflow: http://stackoverflow.com/questions/2209030/edited-mysql-large-myisam-table-40mln-records-having-index-that-is-very-slow/2209223#2209223 I raised the point because sometimes when you create a small table to use as a 'list field', you might fall in this pattern. On the other hand, after rereading your question about province exits, it seems it's not your case. Sorry for the noise. -- Javier -- 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.
