database question: how long would you expect it to take to run an (unindexed) SELECT blah FROM foo WHERE x=2 on 1GB/100GB/10TB of data?
-
-
Replying to @HenryR
@HenryR@NovalisDMT so the thing that makes me sad is that I don't really know how to make estimates if I knew the variables2 replies 0 retweets 0 likes -
Replying to @b0rk
@HenryR@NovalisDMT like should I just calculate how long it would take it to read the data from disk at the disk's speed?3 replies 0 retweets 0 likes
Replying to @b0rk
@b0rk @HenryR @NovalisDMT thinking about these things as dominated by IO (disk reads, network between nodes) is a great approximation.
3:35 PM - 11 May 2014
from San Francisco, CA
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.