sql server - Which query would be better for Paging? -

-

which query better paging query 1 or query 2

query 1:

select ceiling(convert(decimal,count(*))/@pagesize) totalpages  table

query 2:

select (count(*) + @pagesize - 1)/@pagesize totalpages  table

bases on sample i'll go query 2

but technically speaking both have same performance in sql server, try executing them , see execution plan.


Comments

Post a Comment

Popular posts from this blog

node.js - StackOverflow API not returning JSON -

-
i using node.js script gather data stackoverflow. know responses gzipped, put code in should take care of that. script follows: var request = require('request'); var zlib = require('zlib'); function getstackoverflowresponse(url, callback){ request(url, {encoding: null}, function(err, response, body){ if(response.headers['content-encoding'] == 'gzip'){ zlib.gunzip(body, function(err, dezipped) { callback(dezipped); }); } else { callback(body); } }); } var url = "https://api.stackexchange.com/docs/questions#pagesize=2&order=desc&min=2014-01-04&max=2014-02-02&sort=activity&tagged=apigee&filter=default&site=stackoverflow&run=true"; getstackoverflowresponse(url, function(questions) { console.log(questions); }); instead of getting json output, i'm getting following response: buffer 0d 0a 0d 0a 0d 0a 0d 0a 3c 21 44 4f 43 54 59 50 45 20 48...
Read more

ios - Apple Push Notifications + TestFlight + Enterprise wildcard provisioning profile -

-
i work in organization have apple enterprise provisioning profile. developing ios application makes use of apple push notifications, , use testflight distribute many users in organizations without having register device ids in testflight. can use enterprise wildcard provisioning profile distribute via testflight application uses apple push notifications? or can use explicit provisioning profile distribute app via testflight without having register employees devices in testflight beforehand? thanks in advance, ido it should work! what enterprise apps? if registered apple's enterprise program , making enterprise apps, no worries...testflight works too. testflight supports enterprise apps , works ad hoc apps distribution. upload enterprise signed app , distribute team , approved members of team have access application installation. source: http://help.testflightapp.com/customer/portal/articles/402851-testflight-faq
Read more

android - Drag and drop in ScrollView -

-
Image
i have imageviews inside horizontalscrollview. i able drag , drop imageviews somewhere else, still maintain scrolling capability. dragging should activated when user starts vertical motion finger. for now, have drag , drop activate on long-press, not solution. to illustrate: i had well. after reading http://techin-android.blogspot.in/2011/11/swipe-event-in-android-scrollview.html adapted code follows: class myontouchlistener implements view.ontouchlistener { static final int min_distance_y = 40; private float downy, upy; @override public boolean ontouch(view view, motionevent event) { switch (event.getaction()) { case motionevent.action_down: { downy = event.gety(); return true; } case motionevent.action_move: { upy = event.gety(); float deltay = downy - upy; // swipe vertical? if (math.abs(deltay) > min...
Read more