Don, Don Arbow wrote:
> Did you read this documentation, especially the last line of this paragraph? > > http://www.djangoproject.com/documentation/db_api/#id3 > > In a newly created QuerySet, the cache is empty. The first time a > QuerySet is evaluated -- and, hence, a database query happens -- Django > saves the query results in the QuerySet's cache and returns the results > that have been explicitly requested (e.g., the next element, if the > QuerySet is being iterated over). *Subsequent evaluations of the > **QuerySet** reuse the cached results.* I did read that documentation, yeah. My understanding of what it said is that: x=SomeModel.objects.all() ...returns a QuerySet, x, which has a cache populated by the query's result at the time of request. What I'm seeing is that, once a QuerySet on this model is cached, then _any_ attempt to get a new QuerySet on this model returns the results cached by the first QuerySet. In other words, I would expect this: >>> x=SomeModel.objects.all() # This gets a QuerySet into x >>> value = x[0] # Some operation to actually fill x's cache >>> print len(x) # Verify that there are some entries in the table 2 <perform an external operation, delete all rows from SomeModel's table> >>> print len(x) # The table is empty, but x has cached values 2 But I would _not_ expect to see this: >>> x=SomeModel.objects.all() # This gets a QuerySet into x >>> value = x[0] # Some operation to actually fill x's cache >>> print len(x) # Verify that there are some entries in the table 2 <perform an external operation, delete all rows from SomeModel's table> >>> y=SomeModel.objects.all() # This gets a new QuerySet into y >>> value = y[0] # Some operation to actually fill y's cache >>> print len(y) # The new QuerySet has the cached result from x! 2 It's the second that I'm seeing - with the result that I can't get at fresh data once any QuerySet in my process has fetched the data once. I know that it's a subtle distinction, but its effect is large. Let me know if I'm not being clear. Thanks, Greg > > Don > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
