Advanced Performance Techniques in ASP.NET 2.0.ppt

,.SeniorConsultantMicrosoftConsultingServicesAgendaSQLServercachedependency(SqlCacheDependency)Customcachedependency(CacheDependency)Post-cachesubstitutionAsynchronouspagewithparallel-processedtasksDatapagingviastoredprocedureReturningmultipleresultsetsfromDBScriptcallback(outofbandcall)SqlCacheDependency&2000SupportTablechangedependenciesonSQL7&2000Requires<cache>configurationsettingsOne-timesetupofSQLServerdatabasePollingmodelSQLServer“Yukon”mandNosetuprequiredNotificationmodelSQLServer7&2000TablelevelnotificationsonlyNotificationwhendataintablechangesRow-imesetupofSQL7/2000TriggersontablesthatparticipateStoredprocedurescalledtocheckOfNote:Entriesincachetable<#oftablesinDBEntriesincache=#-S.-E-dNorthwind–-S.-E-tProducts-dNorthwind–-S.-E-dNorthwind-:SQL‘Yukon’SQLServer‘Yukon’:YukonNotificationsSQLServerCacheDependency(SQLServer2000)Source: