Are SQL queries usually eager or lazy? i.e. does db compute once and then you page through results; or does it compute as you request pages?
-
-
-
-
Replying to @hadleywickham
@hadleywickham np, though YMMV. I would be unsurprised to learn that it was implementation dependent. Nothing says it can't be lazy.1 reply 0 retweets 0 likes -
Replying to @fdaapproved
@fdaapproved@hadleywickham anything that does anything interesting with full table scans (which is most queries) will need to be eager, no?3 replies 0 retweets 0 likes -
Replying to @avibryant
@avibryant@fdaapproved what if the results are too big too fit in memory? The more I think about the more I realise I don't understand2 replies 0 retweets 0 likes
Replying to @hadleywickham
@hadleywickham @fdaapproved I know from working with map reduce that most things can be modeled as merge sorts and single-pass scans.
6:10 PM - 5 Jan 2015
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.