Hello, welcome to Premium Technologies. I am Venket. This is part 119 of the ASP.NET video series. In this video, we'll discuss caching in ASP.NET, which improves the ance and scalability of an application. Caching is the technique of storing frequently used data or pages in memory. Let's understand caching practically with an example. Let's flip to Sequel Server Management Studio. We will be using the TBL Products table in this demo. So, let's go ahead and create this table. This table has three columns: ID, name, and description of the product. Let's go and insert some sample data into this table using this insert script. Finally, let's go ahead and create the stored procedure which simply returns ID, name, and description columns from TBL Products table. Now, since this is a very simple table with 4 columns and 4 rows, when we execute the stored procedure, it will be executed in less than a second. In real time, we may have tables with huge amounts of data and we may be joining multiple tables, so the queries before they actually return data, they might take some time. To introduce some artificial query processing times, I'm going to use "wait for delay" in Sequel Server. So, we are intentionally blocking the execution of this stored procedure for a certain duration. I want to block it for 5 seconds. Now, if we execute the stored procedure, it's going to take at least 5 seconds. Let's go ahead and invoke the stored procedure from an ASP.NET web application. Let's flip to Visual Studio. On this web form, let's go ahead and drag and drop a GridView control, which can display the data from TBL Products table. Let's auto format this so that it looks a little better. Along with the data, I...
Award-winning PDF software
Video instructions and help with filling out and completing When Form 8815 Cashing
