When Form 8815 Cashing 2022-2023

Instructions and Help about When Form 8815 Cashing

Hello welcome to premium technologies I am venket this is part 1 1 9 of asp.net video series in this video we'll discuss about cashing in asp.net cash improves the performance 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 this TBL products table in this demo so let's go ahead and create this table and this table has got three columns ID name and description of the product and let's go and insert some sample data into this table using this insert script and finally let's go ahead and create the stored procedure which simply returns ID name and description columns from TBL products table ok and now since this is a very simple table with 4 columns within that I mean with 4 rows within that when we execute the stored procedure the stored procedure will be executed in less than a second look at the time it took less than a second now 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 so obviously to introduce some artificial query processing times I'm going to use wait for delay in sequel server so there's something called wait for delay so we are intentionally blocking the execution of this stored procedure for you know certain duration I want to block it for overs minutes and 5 seconds okay so basically hours minutes and seconds so we are blocking the execution of this stored procedure for 5 seconds so let me go in and alter the stored procedure ok so...