Cache With A Gridview?
Jan 27, 2010
I have a gidview on a aspx (with a master pag). That is basically a blog, so the grid view can show 100 items or 1.
I have cached like this..at the top
<%@ OutputCache Duration="60" VaryByParam="jh65;su23" %>
And I have cached the SQL Datasource for the Gridview like this
<asp:SqlDataSource
ID="SqlData1"
runat="server"
ConnectionString="<%$ ConnectionStrings:RTT_OPS_con %>"
[Code]....
1) The SQL datasource caches the last query for 15 seconds, so if its called again its uses the cached version. Therefore setting it to 15 seconds may be too short 600 seconds would be better, do you concur ?
2) The Output cache set to two parameters is storing all HTML at in the memory for 60 seconds.
What do you think of the cache strategy , periods two short, ???
NOTE: I cant use SQLDependency cache as the SELECT statement is too complex.
View 1 Replies
Similar Messages:
Mar 29, 2010
Is it correct to implement my caching object like this in my controller :
[code]....
And I Use it like this :
[code]....
View 1 Replies
Feb 25, 2011
We have a wfc layer that wraps the business classes and database access and use a client that lives on the database layer. Amongst our group we are attempting to form standards. Some want to have the client call the web method and pass the page they are requesting and the page size. Pass that to the database and then page in SQL Server use RowNum.Some want to cache the full list of objects in http cache on the service tier and page in memory. They concern here is memory use on the server.
Which would be best for a medium number of users with potentially large number of records to manage (say 30K) Is it better to cache them all in memory and work from there or page at the database as the application scales?
View 1 Replies
Jul 28, 2010
What are the "optimal" parameters for creating an AppFabric cache when you will be storing session state in the cache? MSDN Cache-Related Commands
Powershell command line:
New-Cache [-CacheName] <String> [-Eviction <String>] [-Expirable <String>] [-Force [<SwitchParameter>]] [-NotificationsEnabled <String>] [-Secondaries <Int32>] [-TimeToLive <Int64>]
[code]...
Since I don't want my sessions to be removed unless the session has been abandoned either via code or Session Timeout...For eviction, I would think "None" and for expireable, I would think False.I have tested and calling Session.Abandon does remove the object from the cache. I have also tested to see if by extending my session, the session object in cache is also extended. This does seem to work the "correct" way.
View 1 Replies
Aug 1, 2010
We have a data driven ASP.NET website which has been written using the standard pattern for data caching (adapted here from MSDN):
public DataTable GetData()
{
string key = "DataTable";
object item = Cache[key] as DataTable;
[code]...
The trouble with this is that the call to GetDataFromSQL() is expensive and the use of the site is fairly high. So every five minutes, when the cache drops, the site becomes very 'sticky' while a lot of requests are waiting for the new data to be retrieved.
What we really want to happen is for the old data to remain current while new data is periodically reloaded in the background. (The fact that someone might therefore see data that is six minutes old isn't a big issue - the data isn't that time sensitive). This is something that I can write myself, but it would be useful to know if any alternative caching engines (I know names like Velocity, memcache) support this kind of scenario. Or am I missing some obvious trick with the standard ASP.NET data cache?
View 3 Replies
Feb 24, 2010
We are using HttpRuntime.Cache API in an ASP.NET to cache data retrieved from a database.
For this particular application, our database queries feature a LOT of parameters, so our cache keys look something like this:
table=table1;param1=somevalue1;param2=somevalue2;param3=somevalue3;param4=somevalue4;param5=somevalue5;param6=somevalue6... etc...
we have so many parameters that the cache key is several hundred characters long. is there a limit to the length of these cache keys? Internally, it is using a dictionary, so theoretically the lookup time should be constant. However, I wonder if we have potential to run into some performance/memory problem.
View 1 Replies
Sep 13, 2010
I have use Nhibernate in my MVC Project by me known, Nhibernate have cache on Session and Object. now, I want use HttpContext.Current.Cache (system.web) for cache data something in project. my code same that have problem, haven't it. and that's right or wrong.
View 2 Replies
Feb 26, 2010
I've got a web application that runs of a state server. It looks like soon it may need to distributed and there will be two web servers behind a load balancer.
This works great for session state but my next challenge is Cache
My application leverages heavily of cache. I understand ASP.Net 4.0 will be offering more here but nothing much has been said about the how too.
There are two challenges that I face
1). Each webserver will have its own copy of cache whereas it would be more efficient to put this to a third server the same as session state is put to state server.
2). The real challenge is keeping cache in sync if a simple dataset derived from the database is changed my code dumps that cache item and reloads the cache. That's all well on one webserver but webserver number two wont know to drop that particular cache item and reload it. This could cause some unexpected problems in the application.
For scenario number 2 I could attempt to do some smart coding so server number two knows to dump the cache and reload it.
My guess is someone else has already been here before and there's probably a better implementation approach rather than writing extra code.
Does anyone know how I could achieve the goal of keeping Cache in sync between multiple webservers or even better farm Cache management to another server?
View 2 Replies
Nov 2, 2010
I need to enable caching in my asp.net application, but I do not want to use the webserver's memory for holding cache objects. If I add the page directive for output caching will the page be stored in the asp.net cache object?
View 2 Replies
Dec 12, 2010
I want to be able to maintain certain objects between application restarts.
To do that, I want to write specific cached items out to disk in Global.asax Application_End() function and re-load them back on Application_Start().
I currently have a cache helper class, which uses the following method to return the cached value:
return HttpContext.Current.Cache[key];
Problem: during Application_End(), HttpContext.Current is null since there is no web request (it's an automated cleanup procedure) - therefore, I cannot access .Cache[] to retrieve any of the items to save to disk.
Question: how can I access the cache items during Application_End()?
View 4 Replies
Jan 14, 2010
Im building a image gallery which reads file from disk, create thumbnails on the fly and present them to the user. This works good, except the processing takes a bit time.
I then decided to cache the processed images using the ASP .NET Application Cache. When a image is processed I add the byte[] stream to the cache. As far as I know this is beeing saved into the system memory. And this is working perfect, the loading of the page is much faster.
My question is if there are thousands of images which gets cached in the Application Cache, will that affect the server performance in any way?
View 3 Replies
Oct 28, 2010
You know I have the way to Cache the data I've got from the SQL Server over data caching. In addition I can output cache web user controls.Whats about a web user control contains data from a SQL database? Does it make sense to cache the data and also cache the control?What is the best solution for the combination of these two components?
View 1 Replies
Feb 11, 2011
I have a server control that I developed which generates navigation based on a third party CMS API. Currently I am caching this control using the PartialCaching attribute. The CMS uses cache key dependencies to invalidate the cache when a user makes an edit, however in the case of my server control it does not get invalidated and the updated navigation will not show up until the cache expiration set by the PartialCaching attribute.Here is my two part question:
What is the proper way to programmatically cache a server control, without using the PartialCaching attribute, and adding a cache key dependency?
Is it possible to continue to use the PartialCaching attribute and add a cache key dependency?
View 2 Replies
Nov 10, 2010
I'm using the OutputCache for my pages, and I have a dynamic user control (login/register) . When the user try to sign in, the the control do not change the aspect because I´m using OutputCache. How can I exclude the "login/register" control from the cache?
View 6 Replies
Nov 19, 2010
I am trying to remove the cache using the HttpRuntime.Cache.Remove(key) but invain. I wonder what are the best practices for using HttpRuntime.Cache.
View 2 Replies
May 25, 2010
I have storedprcedure which returns userinformation.. this is my storedprocedure.. which returns student information.. I need to get this cache value in Actionresult method to get the student Id?
how to get the Cache value to the Actionresult method from StudentDB.cs file?
public StudentBE GetStudentInfo(int ID, string type)
{
try
{
var cache = CacheFactory.GetCacheManager();
[code]...
View 2 Replies
Jul 22, 2010
need to write Cache Methods in my asp.net mvc project.. I created one Class called CacheHelper.cs file.. Mainly In my appliction I am using three types GetData() ( getting data from cache)Add() ( Add data to the Cache) Refresh() ( Refresh data) or Flush()
View 4 Replies
Oct 15, 2010
I have ASP.Net application with a simple cache helper. Under VS web server it works fine. Under IIS 6.0 cache doesn't work- object, was saved previos, doesn't returns after a minute (with no exception).
[Code]....
View 1 Replies
Oct 22, 2010
How to use cache dependencies in MVC?So far, I follow the caching tutorial (http://weblogs.asp.net/rashid/archive/2008/03/28/asp-net-mvc-action-filter-caching-and-compression.aspx) but what if changes occured in the database and the page is still cached. [:(]
How to clear cached pages when new data is inserted?
View 4 Replies
Jul 20, 2010
I have MVC 2 site, and I.E is cacheing word documents linked on my site. I know there is a way to clear cache before every action in the controller. But for these links i am not using action, i am just creating regular href links.. Is there anyway i can clear the cache?
View 2 Replies
Nov 15, 2010
does scheduled recycling an application pool affects HttpContext.Application / Cache? I can't find reference for that.I guess yes, as it causes worker process to restart, I want to make sure. I'm talking about iis 6.0 (w3wp.exe).
View 3 Replies
Jun 10, 2010
I need to know what is Cache size. I've read solution on this site for more or less similar question but it partly serves me. As i know i can get values from PerMon, here is function
public static string getCacheSize()
{
PerformanceCounter pc = new PerformanceCounter("ASP.NET Applications", "Cache % Machine Memory Limit Used","__TOTAL__", true);
return string.Format("{0:0.00}%", pc.NextValue());
}
1.it gives me percents when i need KB and there is no item closest to this one in PerfMon
2.it shows 70.5% used while all memory usage is about 50%
View 1 Replies
Aug 9, 2010
What is the best way to cache an entity, so it can be used with linq ?
The following will not work.
using (EN myEN = new EN())
{
if (Cache.Get("CachPerson") == null) // Create Cache [code]....
View 2 Replies
Jan 25, 2010
This one doesn't work while caching renderaction returned result.
<OutputCache(CacheProfile:="ProfileCacheName")> _
Function About()
Return DateTime.Now
[code]...
View 1 Replies
Feb 13, 2011
I'm using C# with ASP.NET. I want to use System.Web.Cache. So I want a cache manager that will care about the caching and implement functions like ADD, GET, and UPDATE.
View 2 Replies
