sql - SqlCacheDependency multiple / bulk updates -



sql - SqlCacheDependency multiple / bulk updates -

i'm trying understand how sqlcachedependency works in mass update situation. understand how set , if create 1 row alter in database cache becomes invalid.

my question if mass update on table has 100 rows

update mytable set col = 1

question

do 100 invalidate notifications, or smart plenty know info changed , 1 notification sent, invalidates info once?

i'm using similar this:example

my concern if invalidates on , on 1 time again hitting database 100 times fresh info , have think of alternative strategy.

regards dotnetshadow

sql asp.net sql-server

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

php - Laravel not returning controller -

php - Laravel not returning controller - i have simple ajax() request that's supposed add together coupon if take take (via pop tag). however, when run page , click on tag , @ in console it's doing returning entire page in html. how can utilize controller specify via routes? new ajax sure that's problem is. what's supposed happen client clicks on take coupon button, ajax processes info controller , shows modal letting them know coupon has been added successfully. a tag <a href="#" class="btn btndefault btnsmall" id="ajaxcoupon">add coupon cart , go on shopping <i class="fa fa-arrow-right"></i></a> ajax $('#ajaxcoupon').click(function(e){ e.preventdefault(); $.get('ajaxaddcoupon', function(data){ $('#successcoupon').foundation('reveal', 'open'); }); }); controller & route ...
Read more

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates -

c# - Confused on how to specify a Platform and Version while using ChromeOptions for RemoteWebDriver with Selenium donNet since recent updates - using c# selenium 2.39 , before, able interact chromeoptions , desiredcapabilities directly. so, if wanted emulate android device on modern version of windows, code snippet might this: // define chromeoptions create chrome deed mobile device chromeoptions options = new chromeoptions(); options.addargument("--user-agent=mozilla/5.0 (linux; android 4.0.4; galaxy nexus build/imm76b) applewebkit/535.19 (khtml, gecko) chrome/18.0.1025.133 mobile safari/535.19"); options.addargument("--disable-sync-passwords"); capabilities = desiredcapabilities.chrome(); //needed find win7 vm rather linux or mac capabilities.setcapability("platform", "vista"); //cef apps tested using selenium2 , grid. //a version of "real" has ...
Read more