[CDBI] Inconsistent reads from database when using web interface
cvicente at network-services.uoregon.edu
Thu Aug 28 23:01:07 BST 2008
I'm hoping someone can give me some hints on this. My CDBI application
has a web interface using mod_perl and Mason. I'm currently using MySQL
The problem I'm running into is that after updating the DB using a web
form, it keeps showing the previous values for a while. Also, reloading
the page shows the value intermittently, as if some of the Apache
processes were returning a cached result, and some weren't. This is
very annoying to the user, who thinks that something is definitely
broken in the application.
I thought I had found the problem when I saw this:
However, after following their directions (setting
|transaction-isolation to READ-COMMITTED|, it is still happening.
The question is, what else could be causing this? Could it be something
in CDBI, and if not, where should I look?
Thanks a lot for your help.
More information about the ClassDBI