I have a memory issue and I'm looking for some suggestions.
class Entity(models.Model):
item= models.OneToOneField(Bigdata, blank = True,null=True)
Bigdata is a table with 150.000+ items
In the admin interface, when I try to add a new Entity item, I have a big memory increment, I think because django load all the Bigdata table in the dropdown list of the fied item (I'm pretty sure, because if the table Bigdata is small I have no problem).
So the problem seems the filling of the Bigdata dropdown list, that loads all the items at once.
How can I deal with this situation? Pagination of Bigdata? Autocomplete instead dropdown list? Any feedback will be very appreciated.
thank you everyone!
Carlo