how to efficiently use _set.all() in django?
<p>Is there a way in django to do the following more efficiently when the number Entry objects is greater than 5000 entries?</p>

<p>models.py</p>

<pre><code>class Entry(models.Model):
    user = models.TextField(db_column='User', blank=True)
    date = models.DateTimeField(blank=True)

class Color(models.Model):
    color = models.TextField(blank=True)
    entry = models.ForeignKey(Entry)
</code></pre>

<p>And let's say that I wanted to get all the colors for each of these entries...</p>

<pre><code>entrys = Entry.objects.all()

for e in entrys:
    print e.color_set.all()
</code></pre>

<p>I want to be able to relate each object to a specific entry. For example, in a csv table like this. </p>

<pre><code>user, color
john, blue
john, orange
bob, green
bob, red
bob, purple
</code></pre>

<p>It takes several seconds to look through all of my entries. Is there a better way?</p>