My app is getting killed by adding m2m relationships. I can bulk create
the objects but for the m2m I have to iterate over them which is super
slow. I'm looking for a way to bulk add the m2m relationships.
Here is a example:
class Sensor(models.Model):
Name = models.CharField( max_length=200 )
Value = models.FloatField()
class DataPoint(BaseModel):
Taken_datetime = models.DateTimeField( blank=True, null=True )
Sensors = models.ManyToManyField( SensorVal, blank=True,
null=True )
for row in rows:
dp = DataPoint.objects.get(Taken_datetime=row['date'])
sensorToAdd = []
for sensor in sensors:
s = Sensor.objects.get(Name=sensor.name, Value=sensor.value )
sensorToAdd.append( s )
dp.Sensors.add( sensorToAdd )
In the actually app I bulk create all the DataPoint and Sensor instances.
The problem is that |dp.Sensors.add( sensorToAdd )| does a lot of hits on
the db. I want a way bulk add all the sensors.
Can I bulk add the m2m relationships in Django? If not, can this be done
in SQL and can you give me some pointers about where to get started? I'm
still a
I'm a beginner with SQL but it seems like there should be a way to group
all these calls together instead of creating one at a time.
I'm using sqlite for development and postgres on the server.
Here is the stack overflow I posted a few days ago:
http://stackoverflow.com/questions/31907116/bulk-add-m2m-relationship-for-multiple-instances
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/4b1c76b1-bd25-440f-b888-07f7a9a0a033%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
