.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

Data caching c#.net

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net
 

Hi Friends,

 

I have a large SQL Database in the server from which I can create a dataset of about 10000 rows. My question is about caching this data. Which type of data caching should I choose (Server side or Client side)? Which one will provide better performance?

 

Thanks in advance




View Complete Post


More Related Resource Links

Velocity: Build Better Data-Driven Apps With Distributed Caching

  

Microsoft Velocity exposes a unified, distributed memory cache for client application consumption. We show you how to add Velocity to your data-driven apps.

Aaron Dunnington

MSDN Magazine June 2009


Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization

  

Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

David Burgett

MSDN Magazine December 2002


Caching in WCF Data Services on Azure

  
I want to enable output caching in my OData service on Azure but I can't get it to work. It doesn't even have to be Velocity or any other distributed caching provider. I just want simple output caching. It can be as simple as the one Scott is talking about over here. I haven't got that example to work though and it seems that other ppl commenting on his article have the same problem as me: getting fresh data all the time. Please guide me

How to enable caching on SSRS that using SSAS cube to bind data

  

Hi All 

 How to set Cach refersh option for a SSRS report that using SSAS cube to bind data 

when i tried to store credential in data source getting error as show below 

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https."

 

 

Regards

Sooraj


Maintaing data caching for Complexed Sql Queries

  

hello friends,


Hey guys i am working on n level product Catelog, I retriving my record at client end by complicated SQL Queries in stored procedure.


for better performance of the Application, i want to implement data caching and view states.

No my problem is that, how would i use the data caching, thugh i have the N level categories for the product and the categories ourselves treated as seprate product.


Any further suggestion would be appriciable.

Thanks and Regards

Inderjeet Singh Khalsa


Lookup conditional caching possible? or flush cache as data changes?

  

Hi Forum

Is there any way to switch caching setting on the lookup up component on-the-fly? I have a lot of lookup components that I want to use full caching setting - some times I know that there will not be a lot of data - so N lookups or partial caching would be better. I could indicate this by using a variable  - I could use a conditional split to make 2 paths - I could make 2 different lookup components but these two cannot point to the next task in the flow since it seams that all data flow task only take one input path.

I could really also use a way to flush the cache when ever a row value changes. In this way I could order the data by Company, and have it use full caching but flush the cache whenever the company id changes. Is this in any way possible?

Thank you in advance

Jay


BCS data caching in Search Server 2010

  
I am using BCS to pull Oracle data into a SharePoint external list via an .asmx web service so that it can be indexed and searched in Search Server 2010.  I created a .NET connector assembly which implements ReadItem() and ReadList() methods to accomplish this.  Both methods call web service methods to either retrieve a record by id or the entire list of data, respectively.  The data retrieved by the web service is done so using an Oracle stored procedure.  

The data retrieved by the web service is refreshed in the Oracle database on a nightly basis by perl scripts.  Because of this, search results muct also reflect any changes on a nightly b

BCS data caching in Search Server 2010

  
I am using BCS to pull Oracle data into a SharePoint external list via an .asmx web service so that it can be indexed and searched in Search Server 2010.  I created a .NET connector assembly which implements ReadItem() and ReadList() methods to accomplish this.  Both methods call web service methods to either retrieve a record by id or the entire list of data, respectively.  The data retrieved by the web service is done so using an Oracle stored procedure.  

The data retrieved by the web service is refreshed in the Oracle database on a nightly basis by perl scripts.  Because of this, search results muct also reflect any changes on a nightly b

caching data in visual web parts

  

Hello ,

I was working with visual web parts and have some custom properties ..when i click apply and then ok the custom property gets applied but when i get back to the edit mode the custom property value in the tool pane is lost...I know that this can be done in Microsoft.sharepoint web parts but just wanted to know how do we save the value in asp.net web parts.

 

Thanks


Data Caching in WCF Service

  

A) Service is hosted in IIS 7.

B) Caller used nettcp binding to communicate with the service

My WCF service reads data from a database table and returns to the caller. this service is called by 50+ users and each user calls the service every 5 seconds.

I am looking at ways to cache this data in the service rather than read the data everytime from database. Can you suggest good caching mechanism in this scenario

PS: Data in the database table is refreshed at random intervals (at peak times as frequent as every 5 sec and in off peak times about once per minute)


Bug in SP? XSL Link + Data Caching enabled

  

In our BDC webparts we have "Enabled data caching" checked, and we have specified an XSL Link. Both our XSL file and the page that the webpart is on are published as major versions. When I go to the page, I get the strangest behavior: the webpart shows all of its data, but it says in red "Unable to connect to BlahBlahInstance. Administrators please see the server log for details".

This error does not occur if the page is a draft. It only occurs if the page is published, and it occurs whether or not the XSL file was published before or after the page. Even more strangely, the error shows up randomly: that is, if I refresh the page over and over, sometimes it shows up, and sometimes it does not. The error also does not occur if data caching is not enabled.

Any information about this issue would be appreciated. Thanks.


Caching data to share between workflow instances

  

I have a wf4 workflow that correlates an SMS message to an internal input channel. For part of the workflow I have a code activity that uses LINQ to SQL to load up a bunch of input channels (rows from a table) from a SQL db. For each workflow instance, the query is run each time against the db.

Is there a mechanism or model people use to cache this sort of stuff (table data) so that each workflow instance can use that instead of re-querying?


Caching data from sql server

  

Hi everyone! I´m trying to find a way to store some sql data on the server (memory?) in order to save many connectios to the database that will almost everytime return the same. I'm thinking (if possible) a way that the server (every XXX seconds, minutes, hours) refresh it´s memory data from the database. So every new query from a client is populated with the data in memory instead of the database. Hope i wrote it in the right place and somebody could help me. Thanks in advance.

PD: Im working in asp.net 4 w/ visual studio 2010 and sql server 2008. 


Business Data List Caching

  

I'm trying to implement Business Data Lists hitting our DBMS. The queries are very resource intensive, but the data is not going to change much day to day.

Even though I have the "Enable Data View Caching" enabled and the Data Caching Timeout set to 24 hours, 8 hours, etc etc I'm still seeing trips to our DBMS.

What gives? I thought DVC was supposed to enabled out of the box on these web parts? http://support.microsoft.com/kb/2000112 This says it won't work on non Publishing Pages, but (as far as I know) all my pages are publishing pages.


Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

  
In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

  
In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend