How to disable Django query cache?

by

I came across behavior that I thought was some kind of caching, but it turned out to be database transactions fooling me.

I had the problem where in another process, items were get added to the database, and I wanted to monitor progress of the other process, so I opened up a django shell and issued the following:

>>> MyData.objects.count()
74674

>>> MyData.objects.count()
74674

The value wasn’t changing, even though it actually was in the database. I realized that at least with the way I had MySQL & django setup that I was in a transaction and would only see a “snapshot” of the database at the time I opened the transaction.

Since with views in django, I had autocommit behavior defined, this was fine for each view to only see a snapshot, as the next time a view was called it would be in a different transaction. But for a piece of code that was not automatically committing, it would not see any changes in the db except those that were made in this transaction.

Just thought I would toss this answer in for anyone who may come upon this situation.

To solve, commit your transaction, which can be manually done like so:

>> from django.db import transaction
>> transaction.enter_transaction_management()
>> transaction.commit() # Whenever you want to see new data

More Related Contents:

  1. Django’s ManyToMany Relationship with Additional Fields
  2. Is it possible to generate django models from the database?
  3. What is caching?
  4. What are the main differences between Redis Pub/Sub and Redis Stream?
  5. What’s the difference between identifying and non-identifying relationships?
  6. Difference between partition key, composite key and clustering key in Cassandra?
  7. Android Pre-Populated Database [duplicate]
  8. How to handle authentication/authorization with users in a database?
  9. What is an ORM, how does it work, and how should I use one? [closed]
  10. What’s the difference between a catalog and a schema in a relational database?
  11. How can I merge many SQLite databases?
  12. Difference between scaling horizontally and vertically for databases [closed]
  13. How to import load a .sql or .csv file into SQLite?
  14. Spring Security 3 database authentication with Hibernate
  15. Is it fine to have foreign key as primary key?
  16. What is the best way to keep passwords configurable, without having them too easily available to the casual human reader?
  17. How to get english language word database? [closed]
  18. What’s the best strategy for unit-testing database-driven applications?
  19. What are the use cases of Graph-based Databases (http://neo4j.org/)? [closed]
  20. What are the advantages of using a single database for EACH client?
  21. Run a single Maven plugin execution?
  22. How to create an auto delete mechanism for firestore? (deleting data after time period) [closed]
  23. Do stored procedures run in database transaction in Postgres?
  24. What is a View in Oracle?
  25. Convert SQLITE SQL dump file to POSTGRESQL
  26. Alternatives to Entity-Attribute-Value (EAV)?
  27. Spring Batch Framework – Auto create Batch Table
  28. CAP theorem – Availability and Partition Tolerance
  29. Delivery of JMS message before the transaction is committed
  30. DB design for microservice architecture [closed]

Leave a Comment