Re: Django ORM exhibiting caching like behavior in a non web based daemon script

I'm using MySQL 5.1.33 I shifted the db engine to MyISAM from INNODB and everything worked like a charm. Then I switched it back to INNODB to test the pythonic workarounds from http://groups.google.com/group/django-users/browse_thread/thread/e25cec400598c06d/55fa3724d2754013?#55fa3724d2754013

Re: Django ORM exhibiting caching like behavior in a non web based daemon script

On Thu, Jun 25, 2009 at 4:48 PM, afrobeard wrote: > > Thanks for the reply Alex, however I beleive I might have > miscommunicated the problem a big. The actual format of the daemon is > somewhat like this:- > > 1while True: > 2rs = Inqueue.objects.filter(processed =

Re: Django ORM exhibiting caching like behavior in a non web based daemon script

Which backend are you using? If you happen to be using MySQL with InnoDB, and you haven't altered the default settings you are probably using an isolation level of REPEATABLE-READ. You can read more about that setting here

Re: Django ORM exhibiting caching like behavior in a non web based daemon script

Thanks for the reply Alex, however I beleive I might have miscommunicated the problem a big. The actual format of the daemon is somewhat like this:- 1while True: 2rs = Inqueue.objects.filter(processed = 0).order_by('-timestamp') 3for item in rs: 4.1 processitem(item) 4.2

Re: Django ORM exhibiting caching like behavior in a non web based daemon script

On Thu, Jun 25, 2009 at 3:31 PM, afrobeard wrote: > > I have a problem where I'm using Django, specifically the ORM in a non > web based daemon script to process some data from a site, by setting > the environment variables respectively so that it knows where the > settings

Django ORM exhibiting caching like behavior in a non web based daemon script

I have a problem where I'm using Django, specifically the ORM in a non web based daemon script to process some data from a site, by setting the environment variables respectively so that it knows where the settings module is, etc I'm running the following query:-