problems with cached results

Last Post 02 Aug 2004 06:52 PM by simonliew. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dan99212
New Member
New Member

--
02 Aug 2004 06:04 PM
I am the administrator of an online dating site. We recently migrated to asp.NET from ASP 3.0. Since then, when a user runs a search the same results are always displayed. Any new members in the database do not show up in the results. I am not sure if this is a .NET issue or a SQL Server issue.

Any help would be appreciated.

Thanks
Dan
simonliew
New Member
New Member

--
02 Aug 2004 06:52 PM
Dan,
Just a note, have you checked the coding for any caching? There's a caching function in ASP.NET that looks something like HttpContext.Current.Application.Item(key) = objValue that caches the SQL query result. Usually SQL Server doesn't return the same result when we query it.
And to clear the buffer cache, you can use DBCC DROPCLEANBUFFERS. This might slow some queries down since cache is empty. You can check you coding and try clearing your SQL buffer and try again to see if it's SQL cache.

Simon
You are not authorized to post a reply.

Acceptable Use Policy