• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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.
0
-Dman100-
Asked:
-Dman100-
  • 3
  • 3
  • 2
2 Solutions
 
surajgupthaCommented:
Can you debug? If so can you check if the database is actually returning the changed values or the old values?
0
 
JimBrandleyCommented:
Are you caching any of the retrieved data in the application cache to speed rendering?

Jim
0
 
-Dman100-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.
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
surajgupthaCommented:
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..
0
 
JimBrandleyCommented:
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
0
 
-Dman100-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.
0
 
JimBrandleyCommented:
Something is cached. Either there are pages cached or something is placing the data into a cache that is used to generate the pages.

Jim
0
 
surajgupthaCommented:
In your development environment when the queries are fired, can you check if the latest data is fetched? If the latest data is fetched my guess is that the pages might be cached at the client.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now