Link to home
Start Free TrialLog in
Avatar of -Dman100-
-Dman100-Flag for United States of America

asked on

possible caching problem

I'm having some trouble locating the cause of what I think is a caching error in my application.  I have some database driven areas of my site...i.e. careers section, press releases, what's new, etc.

When I make an update in the database to these tables, the changes are not immediately reflected in the site.  They should be?  It takes about several hours before the changes are seen in the website.

There are no errors.  The changes just don't show up until several hours later.  This appears to be a caching error.

I have caching turned off in the web.config file.  I'm kind of lost of what to look for or how to troubleshoot this?

Any help is appreciated.

Thanks.
Avatar of surajguptha
surajguptha
Flag of United States of America image

Can you debug? If so can you check if the database is actually returning the changed values or the old values?
Are you caching any of the retrieved data in the application cache to speed rendering?

Jim
Avatar of -Dman100-

ASKER

thanks for replying ot my post.

How do you check if the database is returning the changed values to the application?  I ran the stored procedure in Query Analyzer to confirm the new values and everything looks good.  The correct values are there.  It just doesn't display in the application until several hours later.

the CacheEnabled is set to FALSE so yes, we have the caching ready to speed rendering, but it is not enabled at the moment.
What i meant is for you to try debugging the application and in the lines that read from the database can you see if the value is returned? My guess is that if it reaches as far as the line that fetches the data , it should fetch the latest values. Can you see if it reaches as far and if it does if the values are fetched? Please debug and let us know..
Does the problem appear:
1. Only in production, or can you reproduce it in a development environment?
2. For a new session, started after the data changes were committed to the DB?

Jim
Hi surajquptha and Jim  Brandley,

I can reproduce the issue in my development environment.  I can go into the database modify a record, run the application and the change does not show up.  I can return a few hours later, run the application and the change is now showing  up.

The problem does occur when a new  session is started, closing my browser and re-opening my browser.  Depending on how long before I start the new session thte changes will not show up.

I'm trying to debug and see if the application is tetching the data, but it should because nothing changes except for the difference in time....a few minutes to a few hours?

Thanks for your help.
Regards.
ASKER CERTIFIED SOLUTION
Avatar of JimBrandley
JimBrandley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial