We help IT Professionals succeed at work.

possible caching problem

-Dman100-
-Dman100- asked
on
228 Views
Last Modified: 2013-11-26
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.
Comment
Watch Question

Can you debug? If so can you check if the database is actually returning the changed values or the old values?
Top Expert 2007

Commented:
Are you caching any of the retrieved data in the application cache to speed rendering?

Jim
-Dman100-Software Consultant

Author

Commented:
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..
Top Expert 2007

Commented:
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
-Dman100-Software Consultant

Author

Commented:
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.
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.