On 12/12/2010 06:45 AM, Alex Gaynor wrote:
Yes, if you're using iterator you'll have Django storing 100 items at a time. That being said I believe I read that some of the database wrappers do their own caching (it's either mysqldb or psycopg2, I dont' remember which).
They both do. They have their own explicit ways to use server-side cursors ([1],[2]) but not by default. There was a discussion here (or several) about the need to reevaluate the old decision in Django to stick to defaults but it was never actually done.
P.S. My personal opinion is that Django definitely needs an explicit way to control this both from settings and from queryset.
[1]: http://mysql-python.sourceforge.net/MySQLdb-1.2.2/public/MySQLdb.cursors.SSCursor-class.html
[2]: http://initd.org/psycopg/docs/usage.html#server-side-cursors -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
