What is Caching my DB

[Siah]

I just launched my django site for a client. My problem is something
is caching my db data in a bizzar way. Here are some of the behaviours
I get:

- I login, and every other page it makes me login again for a 5 minutes
or so and then it remembers that I am logged in.
- I add a record, it reflects it to the site in close to 5 minutes from
now
- Every other DB related change takes some time to reflect

My temporary domain is (a # # a# r #m # i #n d o t ##c o# m).
Please remove (#, space, and replace dot with .). To see this for
yourself login to the site by going to /admin/ with username and
password: django

Thanks,
Sia

ps. django rocks

[Siah]

Re: What is Caching my DB

Sorry, this post had to go on Django Users group. I'll post it there.
You may ignore this post here.

Sia

[Ivan Voras]

Re: What is Caching my DB

Siah wrote:[color=blue]
> I just launched my django site for a client. My problem is something
> is caching my db data in a bizzar way. Here are some of the behaviours
> I get:
>
> - I login, and every other page it makes me login again for a 5 minutes
> or so and then it remembers that I am logged in.
> - I add a record, it reflects it to the site in close to 5 minutes from
> now
> - Every other DB related change takes some time to reflect[/color]

Some general points/ideas:

- AFAIK mysql can be setup to do SQL query cache, so maybe it's
returning stale data somewhere
- If the web server is actually a cluster (e.g. multiple web servers
under one DNS address) then it may be misconfigured not to share session
data (I know this happens on SourceForge.net with PHP).
- Apache can also be set up to cache HTML (for example, if used as a proxy).
- Your browser may be caching HTML also, if you don't send Cache-control
and Pragma headers.

I'm not familiar with django, so these points may or may not be
applicable :)

[Siah]

Re: What is Caching my DB

Helpful Hints Ivan. Thanks for the points.
Sia