3 ms·

What’s wrong with seconds when implementing / running a new query? Obviously disk iops are the bottleneck with such a system, so encouraging folks to conserve

What’s wrong with seconds when implementing / running a new query? Obviously disk iops are the bottleneck with such a system, so encouraging folks to conserve them by charging for bytes scanned seem like a good measure. Won’t an enterprise implementing this themselves or using third party tools have to scale out their index nodes based on the amount data queries are scanning?

tyingq 8y ago
"so encouraging folks to conserve them by charging for bytes scanned seem like a good measure." I wonder if it warns you about potentially expensive button clicks. A little cartesian join, and...ouch.
- zwily 8y ago
  It’s not powerful enough to do a Cartesian join (yet?). Most you can do is scan once over a big dataset.
  - tyingq 8y ago
    Hmm. I wonder if an "index only" query charges for the scan of the index, or a full table scan.
    - zwily 8y ago
      AFAICT, there is no indexing. It appears to just scan the logs as necessary. Maybe indexing will come later.
- dberg 8y ago
  Bigquery has a cool function like this where it will tell you the cost of the query before you run it.