index > .NET Framework Data Access and Storage > Global Caching

Global Caching

I've a windows application which connect to SQL server every second and gets data. Many user uses this application and it put lots of stress on the SQL server. So I would like to use Caching for this. What I like to do is, run an application which connect to SQL server, fills a dataset and caching it, another application that all other users use and get the data from the cache already created by the other appln and not from SQL server. Is it possible with Visual Studio 2005. Please let me know how with example?

Thanks,

Antony

Antony1

Yes you can, I've done this with a windows app recently.

My win app connects to a service that runs on the application server. The service contains my DAL code and handles all the db connections etc. Within the service, I have a 'cached data' section that works like this...

1:

Dylan Morley

Thanks Dylan.

Cheers,

Antony

LotusGuru

reply 3

You can use google to search for other answers

More Articles

• Number of Query values and destination fields are not the same

• Database update works as console app, fails as service

• getting info from database

• OledbConnection and DSN

• Add rows to DataTable

• calling database in aspx file

• Store/retrieve Avi files to/from Sql Server

• DataTable - Null Object Reference Error

• There is already an open DataReader associated with this Command ...

• What happens underneath the BulkCopy Object of ADO.NET 2.0

Welcome to Bokebb New Update

New Articles

• Problem | Oracle 9i Release + With Vb.Ne
• SQL Server 2005 JDBC Driver and x64 sys
• help: I need to view all the tables in a
• retrieve schema info for a SQL statement
• How to validate data against schema and
• Seek suggestion on .NET support options
• Parameter within WITH-Clause in MDX
• Adding column to a dbf file
• How to control root node name for the Da
• Output File From DataSet.WriteXml() is M
• DataAdapter inserting values into the da
• Can't figure out this error message
• What is the maximum number of tables in
• Help with queries
• SQLConnection.GetSchema and ForeignKeys

Hot Articles

• Problem with calculated columns - no aut
• database connections string and getting
• import / parse DIF files (Data Interchan
• The provider could not determine the Dec
• [OTP]mouseover and open new page
• Issues with updating Access DataSource
• "Reciclating" DataAdapter
• after publish the program, if i wanna ch
• SQLPrepare(): Debug vs Release
• Login Controls Visual Studio 2005 Wizard
• Update Excel Data
• sqldatareader?
• DataGridView Detail Row Saving
• SQL Table Lookup Methods
• ComboBox, CheckBox in bound forms

Recommend Articles

• OLEDB + SQL
• Read data from an Opened excel file with
• Time Zone Problem in Web Service
• vb.net and access
• OnTableNewRow for a derived DataTable do
• datatable column name and datatype
• Returning controlled SQL data
• Compiling Stored Procedures within Oracl
• OleDbCommandBuilder doesn't generate any
• retrieve schema info for a SQL statement
• Isolation.ReadUnCommitted Locking Proble
• international character support in ms ac
• how to open excel file (on server), writ
• Connection String
• Advice needed - persist data during a se