C# - Store Dynamically Changing Data Into Server Cache?
Apr 7, 2010
EDIT: Purpose of this Website: Its called Utopiapimp.com. It is a third party utility for a game called utopia-game.com. The site currently has over 12k users to it an I run the site. The game is fully text based and will always remain that. Users copy and paste full pages of text from the game and paste the copied information into my site. I run a series of regular expressions against the pasted data and break it down. I then insert anywhere from 5 values to over 30 values into the DB based on that one paste. I then take those values and run queries against them to display the information back in a VERY simple and easy to understand way. The game is team based and each team has 25 users to it. So each team is a group and each row is ONE users information. The users can update all 25 rows or just one row at a time. I require storing things into cache because the site is very slow doing over 1,000 queries almost every minute.
So here is the deal. Imagine I have an excel EDIT(Excel is just an example of how to imagine it, I don't actually use excel) spreadsheet with 100 columns and 5000 rows. Each row has two unique identifiers. One for the row it self and one to group together 25 rows a piece. There are about 10 columns in the row that will almost never change and the other 90 columns will always be changing. We can say some will even change in a matter of seconds depending on how fast the row is updated. Rows can also be added and deleted from the group, but not from the database. The rows are taken from about 4 queries from the database to show the most recent and updated data from the database. So every time something in the database is updated, I would also like the row to be updated. If a row or a group has not been updated in 12 or so hours, it will be taken out of Cache. Once the user calls the group again via the DB queries. They will be placed into Cache.
The above is what I would like. That is the wish.In Reality, I still have all the rows, but the way I store them in Cache is currently broken. I store each row in a class and the class is stored in the Server Cache via a HUGE list. When I go to update/Delete/Insert items in the list or rows, most the time it works, but sometimes it throws errors because the cache has changed. I want to be able to lock down the cache like the database throws a lock on a row more or less. I have DateTime stamps to remove things after 12 hours, but this almost always breaks because other users are updating the same 25 rows in the group or just the cache has changed.This is an example of how I add items to Cache, this one shows I only pull the 10 or so columns that very rarely change. This example all removes rows not updated after 12 hours:
DateTime dt = DateTime.UtcNow;
if (HttpContext.Current.Cache["GetRows"] != null)
{
[code]...
View 4 Replies
Similar Messages:
Dec 13, 2010
one of my stored procedure has 4 select statments and gets data from large tables,
can i explicitly store result of stored procedure into buffer cache?,
and when calling stored procedure, than returns data from buffer cache?
View 2 Replies
Apr 21, 2010
I have a DataTable with about 10,000 rows in it.
I would like to store this data once for aspx page. When the user selects different options in the page, data is further selected from the already stored DataTable.
I tried using the ViewState, but as soon as the data grows beyond 100 rows, performance degrades.
View 1 Replies
Nov 13, 2010
What would be the best way of going about doing this;
On my website I am putting some short stories in and allowing people to change the name of the characters in the story to match their own. I was going to keep the stories in a SQL DB but not quite sure how I would go about changing the names of the characters dynamically?
Would I be best using say (Name1), (Name2) etc in the stories in the DB then changing it using a string query on the code behind or is there a better / quicker way to acheive this?
View 3 Replies
May 28, 2010
In my form there are about 6 parameters and two of them have multiple values, upto 6. I'm imposed by the restrictions that I can't change the table structure. The table have 8 fields one for ID as primary key, one for foreign key and other to store data. The two fields which have multiple values are color and size. A size may have different colors and vice versa.
The programmer which have developed the site earlier used a stored procedure to store the data in database. And he implemented the above scenario one by one for each color/size. Now I have to put all in one.
How can I do this. As I can't change the table structure at current moment as this will disturb the whole E-commerce site.
View 3 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 15, 2010
I have a grid view that I want to dynamically change based on data in my page. Specifically I want to change one of the title items and I want to hide a column based on a certain condition.
View 3 Replies
Mar 8, 2011
It should store plain HTML fragments of a page like the standard Output cache in asp.net .The HTML may contain dynamic content from a database.When an object is updated in the database all the cached HTML fragment containing that particular object should be destroyed and re-cached next time it will be requested.
There is a separate admin tool to handle all data in the database so I can easy store the Id's in a cachetable when an object is invalid. I can also make a request to a page that destroy all cached HTML fragment for that object.
But when I write the markup, how could I do to store and retrieve a particular segment from the cache? Of cause I could do this in code behind and have the markup in a string but I don't want that. I want to have the markup as intact as possible.
View 2 Replies
Jan 24, 2011
If i enable client side cache in my asp.net application where it store that cache controls in my computer
View 1 Replies
Mar 3, 2011
I've seen numerous examples of people storing DataTables into the Cache, but I am just wondering, do the same rules apply to the Cache that apply to the Session? The one rule I am most concerned with is:Do not store unserializable objects into the Session. Just because you can doesn't mean it is guaranteed to work So ultimately my question is:Can you store unserializable objects into the Cache?I reasearched this for a while, reading numerous posts and even reading the chapter about Cache in my ASP.NET 3.5 book and I cannot find it anywhere.I am going to put my DataTable into a DataSet then into the Cache,but is this necessary?
View 3 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 12, 2010
I have a reportViewer control and I dynamically setting the report path and dataset in the page load event if it is not a post back. This first report displays without issue. However, when I attempt to change the report path / dataset via the onChange event from a dropdown list I get the following error:
A data source instance has not been supplied for the data source "Summary_DataTable1".
This code works fine and the summary report is displayed the first time the page is loaded.
[code]....
View 6 Replies
Nov 1, 2010
How do i dynamically change the value of dataitem in repeater control(.net 2.0,VS 2005)..i have repeater something like this :
<asp:Repeater ID="rptGameInfo" runat=server OnItemDataBound="itemDataBound_rptGameInfo" >
<HeaderTemplate >
</HeaderTemplate>
<ItemTemplate >
<asp:Label ID="lblLoc" runat=server Text="Location:" ></asp:Label><%# Eval("GAME_LOCATION")%><br />
</ItemTemplate >
</asp:Repeater>
and it shows the result like this:
location:"Select"
If location is "Select" i want to change it to "n/a". So i am trying to capture it in itemDataBound even something like this
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
DataRowView row = e.Item.DataItem as DataRowView;
string location = row["GAME_LOCATION"].ToString();
if (location == "Select")
{
// e.Item.Text = "n/a";>>
}
Does e.Item some 'text' sort of property ,i can set the value to?
View 4 Replies
May 17, 2010
I have a aspx where i have thumbails of pictures in listview, once i click on a picture, picture shows up as big next to list view. Now what i want to do is, have a red color border around the thumbail of picture which is show big at the center. check the Picture I just want to change the CSS class of the image selected in the listview. I get to know which image id is selected through query string PageNO or if <%#Eval("PageNo") %> is =2 then second image css class should be redBorder else imgBorder1 ASPX Page
[Code]....
Code Behind:
[Code]....
View 12 Replies
Jun 1, 2010
I have a simple web form with a dropdownlist and a ReportViewer. I would like to dynamically change the report within the viewer when the user makes a selection in the dropdownlist. I think I need to alter the ObjectDataSource that the ReportViewer is using. I've tried a few things without success.
View 2 Replies
Aug 25, 2010
How to change the skin ID of the dynamic controls
View 2 Replies
Feb 15, 2011
i'm developing a "small" warehouse-management WebApplication for few users(5-10 parralel) but with a complex authorization system(checking if pages,menus,TabPanels, UserControls and even single controls are visible or enabled) and permanent and frequent access. Because i've only limited experiences with the ASP.Net MembershipProvider, i'm unsure what's the best approach for following goal:
I want to hold all users, roles and frequently used masterdata in the Cache(in a Dataset). Hence every readonly access should be faster and causes less traffic than always using the database. On updates,deletes and inserts i would update the cached dataset and also the database.Can i use or extend the SqlMembershipProvider to achieve this goal and if possible how?Should i use the stored-procedures from asp.net or simply use the standard CreateUser, GetUser, DeleteUser-functionality? Does this approach makes sense at all?
View 1 Replies
Jan 31, 2011
I would like to know what is the best way to include Cache-Control: no-cache, no-store in authenticated pages in DotNetNuke 5.4.4. In fact, I want to prevent caching in IE6/7 and FireFox as well.
View 1 Replies
Feb 2, 2010
Is it possible to change back ground image of a datalist at run time??
View 2 Replies
Dec 30, 2010
I want to store object data to treeview node dynamically(while application running) , In windows form i use node.tag = ? , and it it ok , i try node.DataItem = something , but it is readonly , so how would i store object data in asp.net
View 3 Replies
May 7, 2010
I'm trying to change the text of a GridView label in an ItemTemplate and I am having some issues. I searched all over and can't find a solution. This is what I am trying to do...
I have a GridView that has a comment field. Normally when the page is rendered the comment field is truncated using a truncate class that limits field length. The full contents can be displayed in a tooltip when the comment field is hovered over. That part works fine.
I also have an export to Excel class that will take the Gridview and export it to Excel and that part works fine as well...
Now the issue... Because of the truncated field, when I do an export it will export exactly what is in that field, the truncated version of a comment. When the export button is clicked I need to change the .text value of the label that is in the GridView ItemTemplate
From this truncated version...
[Code]....
And then back again after the export routine is complete.
I have accessed the contents of a label before using FindControl but never set a value, is this possible? Also, I have captured what is in the comment field on RowDataBound but by that time, it is already truncated.
View 2 Replies
Oct 28, 2010
I am working on a website where the content has to be displayed in English, Polish, Slovak and Czech. Currently, everytime a special character used in the non-english languages (such as Á or â), it displays as just a normal A or a. I've traced the problem down to the database. Currently the collation is "Latin1_General_CI_AS", and when the special foreign characters are put on to the server, the server saves it as a normal standard english character.
I've looked at several answers, but most seem to change the database collation within the SQL query, and this is something that isn't feasible for me to do (due to the size of the site). What I'm trying to do is find a collation for the database that will allow the foreign characters to be saved as well as the english characters (a bit like how UTF-8 works in HTML).
View 1 Replies
Feb 19, 2010
I need to know how to change aspnetdb to store profile information unique to each user so that I can restrict records in an sql table to only show that user's records.
So if I make a "companyID" int, identity column where would I put it?
Also, when I write the where clause to companyID = profile (companyID) would that work?
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
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