I have a model lets say, MyModel which has a foreign key to another
model say Tag.

class MyModel(models.Model):
    id=models.AutoField(primary_key=True)
    name=models.CharField(max_length=200)
    tag = models.ManyToMany(Tag)

I have approximately 50,000 instances of MyModel and each MyModel can
have 100 Tags.

If I use the above model I will get 5Million entries in a table,
mymodel_tag but I can use all the features of ORM.

However If I write custom methods and treat above field as an array of
integers and write custom code to retrieve/save ids of tags associated
with MyModel, I will have just 50K entries but I will have to write
custom code for retrieval etc.

My Question is :
a) Which one should be used in this case?
b) If I want to write above only using an extra column in mymodel
table which will be the array of ids of all the tags associated with
each MyModel, how do i do that?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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.

Reply via email to