• Data Caching in Asp.net | Tutorial

    How to cache a website and save it in memory using asp.net , how to cache an object from page too ! Do not miss to share your feedback :) Thanks

    published: 04 Aug 2016
  • What is cache memory - Gary explains

    Read more: http://goo.gl/JZ29rB SoC designers have a problem: RAM is slow and it can't keep up with the CPU. The workaround is known as cache memory - find out more here. If you want to connect with Gary and talk about cache memory please visit the Team Android Authority section in the forums: http://www.androidauthority.com/community/forums/team-android-authority.533/ Download the AndroidAuthority App: https://play.google.com/store/apps/details?id=com.androidauthority.app Subscribe to our YouTube channel: http://www.youtube.com/subscription_center?add_user=androidauthority ---------------------------------------------------- Stay connected to Android Authority: - http://www.androidauthority.com - http://google.com/+androidauthority - http://facebook.com/androidauthority/ - http://twit...

    published: 07 Apr 2016
  • Caching application data in asp net Part 126

    Text version of the video http://csharp-video-tutorials.blogspot.com/2013/02/caching-application-data-in-aspnet-part.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-126-caching-application-data.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In parts 119 to 125 of the asp.net video tutorial, we discussed about 1. Caching webforms 2. Caching multiple responses of webforms 3. Fragment caching using user controls 4. C...

    published: 07 Feb 2013
  • Caching UI data (Android Performance Patterns Season 4 ep16)

    You know what screams out “This app is slow” ? A spinner. Especially one that sits around mocking the user while the activity behind it is trying to load UI data. In this video, +Colt McAnlis talks about why spinners “feel” slow to users, and how this is one of the most annoying UI patterns on Android thats really easy to fix. Watch more Android Performance Patterns here: http://goo.gl/4ZJkY1 Join the G+ Community here : http://goo.gl/g7mxmI Subscribe to the Android Developers channel at http://goo.gl/GEh1ds #PERFMATTERS

    published: 26 Jan 2016
  • Caching data in single page apps for fun and profit

    This talk looks at some basic strategies for adding some simplistic caching into a single-page javascript app to improve app responsive and reduce backend load.

    published: 05 Jun 2015
  • How does it work for offline data caching?

    CitiesDirectory is full application solution for iOS version with backend system for content management. I would like to list down for some awesome features at below : iOS App Features 1. Xcode application by using Swift2.0 (Not For Objective C++) 2. UI and Layout are for iPhone screen but it is able to run on iPad too 3. Parallax Effect is using for Cities List Page 4. Horizontal & Vertical scroll are using for Categories and Sub Categories 5. Items are showing with Pinterest Grid 6. Item Details Information 7. User Profile to manage their information 8. User Account Register, Forgot Password 9. Favourite/UnFavourite For Item 10. Like/Unlike For Item 11. Item Reviews 12. Inquiries for User Feedback 13. Share on Facebook, Tweet on Twitter 14. News Feed from City 15. Push Notificatio...

    published: 15 Mar 2017
  • angular data caching

    This video shows how to do data caching using angular and also promises in angular factory.

    published: 23 Nov 2016
  • "Caching at Netflix: The Hidden Microservice" by Scott Mansfield

    Netflix is well known for championing the microservice model, but within the complex layers of dependencies is a hidden service: the caching layer. The Netflix customer experience relies heavily on caches to provide a high-volume, low latency, globally available data layer that backs our stateless services. Throughout a typical customer experience, from sitting down on the couch through playing a movie, caches play a role in every interaction. The use cases here range from session storage to video history to subscriber status, all of which benefit from the stability and fault tolerance of EVCache, the primary caching system in use at Netflix. The second part of the talk will peek under the hood of EVCache and its open source components: the EVCache client library, Rend, Memcached, and the...

    published: 17 Sep 2016
  • Lookup Data Caching Performance Boost

    The video demonstrate 2 points: 1. How to performance analysis of an application in Visual Studio 2010, and 2. The caching of lookup data in ASP.Net application boosts the performance of fetching lookup data .

    published: 22 Dec 2011
  • Loading and Caching Images! (SDWebImage : Swift 3 in Xcode 8)

    Hacksaw Academy 14 Day Free Trial - https://fbit.co/32fk Today I show you how easy it is to use SDWebImage to load and cache images inside of your app using Swift 3 in Xcode 8. Enjoy! SDWebImage - https://github.com/rs/SDWebImage ~Social Stuff~ Website - http://www.archetapp.com Twitter - http://www.twitter.com/archetapp Snapchat - archetapp

    published: 29 Sep 2016
  • Web Application Session/Data Caching: Using ETAGs and an intermediate to keep data fresh

    Using the ETAG header to help your web app understand if what is in it's memory needs to change. This is very important if you have 1000's of connections hammering away at your server and you're finding deserializing sessions for each request is costing too much CPU (which sometimes.. often.. it does)

    published: 31 Jul 2013
  • Caching 2 TB data with Hazelcast

    This is the 2 TB cache demo that is done for Mozilla team. The requirement of the demo can be found at https://wiki.mozilla.org/Socorro:ClientAPI . And the source code for the demo is available at https://github.com/fuadm/socorro-hazelcast-poc . At this demo we use Hazelcast Management Center to visualize the cluster and Hazelcast cloud tool to deploy applications on EC2 easily.

    published: 11 Apr 2011
  • ASP.NET Caching Data

    Лекция: ASP.NET Caching Data Курс: Училищна академия - Уеб разработка с ASP.NET MVC https://telerikacademy.com/Courses/Courses/Details/222 Лектор: Ивайло Кенов Дата: 25 февруари 2015 Уебсайт на Академията на Телерик: http://academy.telerik.com Следете за предстоящи безплатни обучения на Академията на Телерик във Facebook: http://www.facebook.com/TelerikAcademy.

    published: 09 Mar 2015
  • Distributed Caching to Data Grids: The Past, Present, and Future of Scalable Java

    Ten years ago, driven by demands for scalable architecture as a result of new internet-inspired business models and the SOA revolution, we saw the birth of the Java distributed caching market. Since then we have seen an explosion of functionality, taking the paradigm on a ride from from simple distributed caching to the more robust data grid. This session presents the history of Java distributed caching and its most important innovations and details how this technology has become integral to enterprises building reliable and scalable large-scale distributed systems (including financial services, travel, online gaming, retail, and many others). Come get a glimpse into how the technology might evolve and how enterprises will adopt it. Copyright © 2013 Oracle and/or its affiliates. Oracle® ...

    published: 31 Jan 2013
  • Exploring Caching in Web Applications

    I've been exploring the topic of caching in web apps. It's been gaining my interest lately. In this video, I'm covering what I'll be talking about. Over the next couple of videos, I'll be experimenting by making a "data feed" and caching the retrieved data. Follow me on the social ----------------------------------------------------- Twitter (Personal): https://twitter.com/tysweezy Twitter (Blog ): https://twitter.com/activatesaga Facebook: https://www.facebook.com/activatesaga/ Website: http://activatesaga.com Links from the video ---------------------------------------- Stackoverflow about caching: http://stackoverflow.com/questions/548301/what-is-caching Laravel Cache docs: https://laravel.com/docs/5.3/cache Redis: https://redis.io/commands Stash: http://www.stashphp.com/

    published: 08 Dec 2016
  • Caching in asp.net Part 119

    Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/caching-in-aspnet-part-119.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-119-caching-in-aspnet.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Caching improves the performance and scalability of an application. Caching is the technique of storing frequently used data/pages in memory. Let us practically understand caching, with an example...

    published: 27 Jan 2013
Data Caching  in Asp.net | Tutorial

Data Caching in Asp.net | Tutorial

  • Order:
  • Duration: 8:58
  • Updated: 04 Aug 2016
  • views: 728
videos
How to cache a website and save it in memory using asp.net , how to cache an object from page too ! Do not miss to share your feedback :) Thanks
https://wn.com/Data_Caching_In_Asp.Net_|_Tutorial
What is cache memory - Gary explains

What is cache memory - Gary explains

  • Order:
  • Duration: 9:09
  • Updated: 07 Apr 2016
  • views: 78159
videos
Read more: http://goo.gl/JZ29rB SoC designers have a problem: RAM is slow and it can't keep up with the CPU. The workaround is known as cache memory - find out more here. If you want to connect with Gary and talk about cache memory please visit the Team Android Authority section in the forums: http://www.androidauthority.com/community/forums/team-android-authority.533/ Download the AndroidAuthority App: https://play.google.com/store/apps/details?id=com.androidauthority.app Subscribe to our YouTube channel: http://www.youtube.com/subscription_center?add_user=androidauthority ---------------------------------------------------- Stay connected to Android Authority: - http://www.androidauthority.com - http://google.com/+androidauthority - http://facebook.com/androidauthority/ - http://twitter.com/androidauth/ - http://instagram.com/androidauthority/ Follow the Team: Josh Vergara: https://plus.google.com/+JoshuaVergara Joe Hindy: https://plus.google.com/+JosephHindy Lanh Nguyen: https://plus.google.com/+LanhNguyenFilms Jayce Broda: https://plus.google.com/+JayceBroda Gary Sims: https://plus.google.com/+GarySims
https://wn.com/What_Is_Cache_Memory_Gary_Explains
Caching application data in asp net   Part 126

Caching application data in asp net Part 126

  • Order:
  • Duration: 17:27
  • Updated: 07 Feb 2013
  • views: 27188
videos
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/02/caching-application-data-in-aspnet-part.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-126-caching-application-data.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In parts 119 to 125 of the asp.net video tutorial, we discussed about 1. Caching webforms 2. Caching multiple responses of webforms 3. Fragment caching using user controls 4. Caching multiple versions of usercontrols Please watch these videos, from the asp.net video tutorial using the link below http://www.youtube.com/playlist?list=PL6n9fhu94yhXQS_p1i-HLIftB9Y7Vnxlo In this video we will discuss about caching application data. It is possible to store application data in the web server memory, using the CACHE object, so that the data can be retrieved faster. For example, let us say, we have a stored procedure that takes 5 seconds to execute and return data. We can cache the data returned by this stored procedure with in an asp.net web application using the CACHE object, so that, next time when we try to access the data, we can get it from the cache, rather than reprocessing the stored procedure again. We will be using "tblProducts" table for this demo. If you need the script to create and populate this table, please refer to Part 122, using the link below. http://csharp-video-tutorials.blogspot.com/2013/01/fragment-caching-in-aspnet-part-122.html Text version of this video is present at the following link http://csharp-video-tutorials.blogspot.com/2013/02/caching-application-data-in-aspnet-part.html The following stored procedure takes 5 seconds to execute and return data. We are using WAITFOR DELAY, to introduce artificial query processing time of 5 seconds. CREATE Procedure spGetProducts as Begin Waitfor Delay '00:00:05' Select * from tblProducts End Copy and paste the following code in WebForm1.aspx.cs. The code is well documented and is self explanatory. protected void btnGetProducts_Click(object sender, EventArgs e) { DateTime dtStartDateTime = DateTime.Now; System.Text.StringBuilder sbMessage = new System.Text.StringBuilder(); // Check if the data is already cached if (Cache["ProductsData"] != null) { // If data is cached, retrieve data from Cache using the key "ProductsData" DataSet ds = (DataSet)Cache["ProductsData"]; // Set the dataset as the datasource gvProducts.DataSource = ds; gvProducts.DataBind(); // Retrieve the total rows count sbMessage.Append(ds.Tables[0].Rows.Count.ToString() + " rows retrieved from cache."); } // If the data is not cached else { // Get the data from the database DataSet ds = GetProductsData(); // Cache the dataset using the key "ProductsData" Cache["ProductsData"] = ds; // Set the dataset as the datasource gvProducts.DataSource = ds; gvProducts.DataBind(); sbMessage.Append(ds.Tables[0].Rows.Count.ToString() + " rows retrieved from database."); } DateTime dtEndDateTime = DateTime.Now; sbMessage.Append((dtEndDateTime - dtStartDateTime).Seconds.ToString() + " Seconds Load Time"); lblMessage.Text = sbMessage.ToString(); } private DataSet GetProductsData() { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(CS); SqlDataAdapter da = new SqlDataAdapter("spGetProducts", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet dsProducts = new DataSet(); da.Fill(dsProducts); return dsProducts; } In this video, we discussed about storing application data in cache, using direct assignment. That is using a key and assiging value to it, as shown below. Cache["ProductsData"] = ds In our next video, we will discuss about all the other options that are available, to store data in the Cache object.
https://wn.com/Caching_Application_Data_In_Asp_Net_Part_126
Caching UI data (Android Performance Patterns Season 4 ep16)

Caching UI data (Android Performance Patterns Season 4 ep16)

  • Order:
  • Duration: 3:14
  • Updated: 26 Jan 2016
  • views: 19459
videos
You know what screams out “This app is slow” ? A spinner. Especially one that sits around mocking the user while the activity behind it is trying to load UI data. In this video, +Colt McAnlis talks about why spinners “feel” slow to users, and how this is one of the most annoying UI patterns on Android thats really easy to fix. Watch more Android Performance Patterns here: http://goo.gl/4ZJkY1 Join the G+ Community here : http://goo.gl/g7mxmI Subscribe to the Android Developers channel at http://goo.gl/GEh1ds #PERFMATTERS
https://wn.com/Caching_Ui_Data_(Android_Performance_Patterns_Season_4_Ep16)
Caching data in single page apps for fun and profit

Caching data in single page apps for fun and profit

  • Order:
  • Duration: 46:39
  • Updated: 05 Jun 2015
  • views: 300
videos
This talk looks at some basic strategies for adding some simplistic caching into a single-page javascript app to improve app responsive and reduce backend load.
https://wn.com/Caching_Data_In_Single_Page_Apps_For_Fun_And_Profit
How does it work for offline data caching?

How does it work for offline data caching?

  • Order:
  • Duration: 2:37
  • Updated: 15 Mar 2017
  • views: 38
videos
CitiesDirectory is full application solution for iOS version with backend system for content management. I would like to list down for some awesome features at below : iOS App Features 1. Xcode application by using Swift2.0 (Not For Objective C++) 2. UI and Layout are for iPhone screen but it is able to run on iPad too 3. Parallax Effect is using for Cities List Page 4. Horizontal & Vertical scroll are using for Categories and Sub Categories 5. Items are showing with Pinterest Grid 6. Item Details Information 7. User Profile to manage their information 8. User Account Register, Forgot Password 9. Favourite/UnFavourite For Item 10. Like/Unlike For Item 11. Item Reviews 12. Inquiries for User Feedback 13. Share on Facebook, Tweet on Twitter 14. News Feed from City 15. Push Notification 16. Search using keyword 17. Explore On MapView and Search by User Current Location 18. Offline Data Caching (New) 19. Animations & Transition (New) Backend Features 1. Super Admin can manage for all cities from the system 2. Different city with own admin account to manage only their city 3. City Registration from public user 4. Super admin need to approve or reject for registered city 5. Categories, Sub Categories, Items CRUD for each city 6. News Feeds CRUD for promotions and discount information 7. Item Like Management 8. Item Review Management 9. Item Favourite Management 10. Item Inquiry Management 11. Send Push Message to Users 12. Data Analytics Using Google Chart API 13. Language config file for localization API Integration 1. Using RestFul API 2. Using JSON to transfer data in between Mobile App and Backend
https://wn.com/How_Does_It_Work_For_Offline_Data_Caching
angular data caching

angular data caching

  • Order:
  • Duration: 9:45
  • Updated: 23 Nov 2016
  • views: 516
videos
This video shows how to do data caching using angular and also promises in angular factory.
https://wn.com/Angular_Data_Caching
"Caching at Netflix: The Hidden Microservice" by Scott Mansfield

"Caching at Netflix: The Hidden Microservice" by Scott Mansfield

  • Order:
  • Duration: 35:22
  • Updated: 17 Sep 2016
  • views: 9578
videos
Netflix is well known for championing the microservice model, but within the complex layers of dependencies is a hidden service: the caching layer. The Netflix customer experience relies heavily on caches to provide a high-volume, low latency, globally available data layer that backs our stateless services. Throughout a typical customer experience, from sitting down on the couch through playing a movie, caches play a role in every interaction. The use cases here range from session storage to video history to subscriber status, all of which benefit from the stability and fault tolerance of EVCache, the primary caching system in use at Netflix. The second part of the talk will peek under the hood of EVCache and its open source components: the EVCache client library, Rend, Memcached, and the not-yet-open-source Mnemonic. We will also look at sister projects that make up the rest of the EVCache ecosystem within Netflix. All of these components combined make up a high-volume, low-latency persistence system that fits many different use cases, even some where a cache might not normally be an obvious choice.
https://wn.com/Caching_At_Netflix_The_Hidden_Microservice_By_Scott_Mansfield
Lookup Data Caching Performance Boost

Lookup Data Caching Performance Boost

  • Order:
  • Duration: 3:00
  • Updated: 22 Dec 2011
  • views: 291
videos
The video demonstrate 2 points: 1. How to performance analysis of an application in Visual Studio 2010, and 2. The caching of lookup data in ASP.Net application boosts the performance of fetching lookup data .
https://wn.com/Lookup_Data_Caching_Performance_Boost
Loading and Caching Images! (SDWebImage : Swift 3 in Xcode 8)

Loading and Caching Images! (SDWebImage : Swift 3 in Xcode 8)

  • Order:
  • Duration: 17:52
  • Updated: 29 Sep 2016
  • views: 15528
videos
Hacksaw Academy 14 Day Free Trial - https://fbit.co/32fk Today I show you how easy it is to use SDWebImage to load and cache images inside of your app using Swift 3 in Xcode 8. Enjoy! SDWebImage - https://github.com/rs/SDWebImage ~Social Stuff~ Website - http://www.archetapp.com Twitter - http://www.twitter.com/archetapp Snapchat - archetapp
https://wn.com/Loading_And_Caching_Images_(Sdwebimage_Swift_3_In_Xcode_8)
Web Application Session/Data Caching: Using ETAGs and an intermediate to keep data fresh

Web Application Session/Data Caching: Using ETAGs and an intermediate to keep data fresh

  • Order:
  • Duration: 6:55
  • Updated: 31 Jul 2013
  • views: 2822
videos
Using the ETAG header to help your web app understand if what is in it's memory needs to change. This is very important if you have 1000's of connections hammering away at your server and you're finding deserializing sessions for each request is costing too much CPU (which sometimes.. often.. it does)
https://wn.com/Web_Application_Session_Data_Caching_Using_Etags_And_An_Intermediate_To_Keep_Data_Fresh
Caching 2 TB data with Hazelcast

Caching 2 TB data with Hazelcast

  • Order:
  • Duration: 6:21
  • Updated: 11 Apr 2011
  • views: 6718
videos
This is the 2 TB cache demo that is done for Mozilla team. The requirement of the demo can be found at https://wiki.mozilla.org/Socorro:ClientAPI . And the source code for the demo is available at https://github.com/fuadm/socorro-hazelcast-poc . At this demo we use Hazelcast Management Center to visualize the cluster and Hazelcast cloud tool to deploy applications on EC2 easily.
https://wn.com/Caching_2_Tb_Data_With_Hazelcast
ASP.NET Caching Data

ASP.NET Caching Data

  • Order:
  • Duration: 42:15
  • Updated: 09 Mar 2015
  • views: 383
videos
Лекция: ASP.NET Caching Data Курс: Училищна академия - Уеб разработка с ASP.NET MVC https://telerikacademy.com/Courses/Courses/Details/222 Лектор: Ивайло Кенов Дата: 25 февруари 2015 Уебсайт на Академията на Телерик: http://academy.telerik.com Следете за предстоящи безплатни обучения на Академията на Телерик във Facebook: http://www.facebook.com/TelerikAcademy.
https://wn.com/Asp.Net_Caching_Data
Distributed Caching to Data Grids: The Past, Present, and Future of Scalable Java

Distributed Caching to Data Grids: The Past, Present, and Future of Scalable Java

  • Order:
  • Duration: 1:01:51
  • Updated: 31 Jan 2013
  • views: 2835
videos
Ten years ago, driven by demands for scalable architecture as a result of new internet-inspired business models and the SOA revolution, we saw the birth of the Java distributed caching market. Since then we have seen an explosion of functionality, taking the paradigm on a ride from from simple distributed caching to the more robust data grid. This session presents the history of Java distributed caching and its most important innovations and details how this technology has become integral to enterprises building reliable and scalable large-scale distributed systems (including financial services, travel, online gaming, retail, and many others). Come get a glimpse into how the technology might evolve and how enterprises will adopt it. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
https://wn.com/Distributed_Caching_To_Data_Grids_The_Past,_Present,_And_Future_Of_Scalable_Java
Exploring Caching in Web Applications

Exploring Caching in Web Applications

  • Order:
  • Duration: 7:30
  • Updated: 08 Dec 2016
  • views: 186
videos
I've been exploring the topic of caching in web apps. It's been gaining my interest lately. In this video, I'm covering what I'll be talking about. Over the next couple of videos, I'll be experimenting by making a "data feed" and caching the retrieved data. Follow me on the social ----------------------------------------------------- Twitter (Personal): https://twitter.com/tysweezy Twitter (Blog ): https://twitter.com/activatesaga Facebook: https://www.facebook.com/activatesaga/ Website: http://activatesaga.com Links from the video ---------------------------------------- Stackoverflow about caching: http://stackoverflow.com/questions/548301/what-is-caching Laravel Cache docs: https://laravel.com/docs/5.3/cache Redis: https://redis.io/commands Stash: http://www.stashphp.com/
https://wn.com/Exploring_Caching_In_Web_Applications
Caching in asp.net   Part 119

Caching in asp.net Part 119

  • Order:
  • Duration: 16:58
  • Updated: 27 Jan 2013
  • views: 60840
videos
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/caching-in-aspnet-part-119.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-119-caching-in-aspnet.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Caching improves the performance and scalability of an application. Caching is the technique of storing frequently used data/pages in memory. Let us practically understand caching, with an example. Create tblproducts table in sql server Create Table tblProducts ( [Id] int identity primary key, [Name] nvarchar(50), [Description] nvarchar(250) ) Populate tblProducts with sample data Insert into tblProducts values ('Laptops', 'Dell Laptops') Insert into tblProducts values ('iPhone', 'iPhone 4S') Insert into tblProducts values ('LCD TV', 'Samsung LCD TV') Insert into tblProducts values ('Desktop', 'HP Desktop Computer') Create "spGetProducts" stored procedure. In this procedure we are using WAITFOR DELAY, to block the execution of the stored procedure for 5 seconds. In real time, we may have large tables, where the query processing can take some time before the data is returned. Table "tblProducts" is a very small table, with only 4 rows. So the stored procedure "spGetProducts" would execute in a fraction of second. Just to simulate artifical query processing time of 5 seconds, we are using WAITFOR DELAY. Create Procedure spGetProducts As Begin Waitfor Delay '00:00:05' Select Id, Name, Description from tblProducts End Link for SQL Server video tutorial that can help you, if you are new to sql server and need help creating tables, stored procedures and understanding sql server concepts. http://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB Now, let us invoke the stored procedure in an asp.net web application, and display the "Products" data in a gridview control. Drag and drop a "gridview" control onto the web form. Copy and paste the following code in the code-behind file Page_Load() event. string CS = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(CS); SqlDataAdapter da = new SqlDataAdapter("spGetProducts", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet DS = new DataSet(); da.Fill(DS); GridView1.DataSource = DS; GridView1.DataBind(); Also make sure you have the following "using" declarations using System.Data; using System.Data.SqlClient; using System.Configuration; We discussed about retrieving data from database in ado.net tutorial. Link for ado.net tutorial is below. http://www.youtube.com/playlist?list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7 At this point, if you run the application, the page takes about 5 seconds to load. This is because, when you request the webform, the web server has to process the web form events, execute the stored procedure, create objects, generate HTML and send that HTML to the client broswer. Now let us cache the webform. To cache a webform, use the @OutputCache page directive. The @OutputCache directive has 2 mandatory attributes Duration - Specifies the time in seconds for which the webform should be cached VaryByParam - Cache multiple responses of a single webform. For now set the value to "None". We will discuss about "VaryByParam" in a later video. When any user requests this Web form for the first time, the web server will process the web form events, execute the stored procedure, create objects, generate HTML and send that HTML to the client browser, and retains a copy of the response in memory for the next 30 seconds. Any subsequent requests during that time receive the cached response. After the cache duration has expired, the next request for the Web form, has to process the web form events, execute the stored procedure, create objects, generate HTML, which is then cached for another 30 seconds. So this web form is processed by the server, once every 30 second, at the most. Next Video: We will discuss about caching multiple responses for a single webform.
https://wn.com/Caching_In_Asp.Net_Part_119
×