SQL server service broker usage with ASP.net cache? -
i have asp.net site (4.5) uses sql cache notification. (using aspnet_regsql.exe
)
the idea sql server tables stored in app's cache .this - not load data on , on again specific table.
the beauty asp.net's cache
can automatically remove table cache
(and load again - optionally) when data modified on table.
it done via web.config :
<system.web> <caching> <sqlcachedependency enabled="true"> <databases> <add name="northwind" connectionstringname="appconnectionstring1" polltime="500" /> </databases> </sqlcachedependency> </caching> </system.web>
but way works polling main sql cache notification table (which holds table names , counters)
question:
i know service broker can used instead . how mechanism different opposed polling? mean - when table changed - there trigger updates main table how asp.net knows counter (which represent change) has been increased ? asp.net still polls ?
Comments
Post a Comment