How to optimize a sort based on “latest” related model
How to optimize a sort based on “latest” related model So say we have two models class Product(models.Model): """ A model representing a product in a website. Has new datapoints referencing this as a foreign key daily """ name = models.CharField(null=False, max_length=1024, default="To be Scraped") url = models.URLField(null=False, blank=False, max_length=10000) class DataPoint(models.Model): """ A model representing a datapoint in a Product's timeline. A new one is created for every product daily """ product = models.ForeignKey(Product, null=False) price = models.FloatField(null=False, default=0.0) inventory_left = models.BigIntegerField(null=False, default=0) inventory_sold = models.BigIntegerField(null=False, default=0) date_created = models.DateField(auto_now_add=True) def __unicode__(self): return "%s - %s" % (self.product.name, self.inventory_sold) T...