4 ms·

Just to be clear, the JOINS were removed for the vertical sharding prior to looking at Cloud Spanner. Cloud Spanner fully supports complex JOINS of many times (

by deesix 10y ago

Just to be clear, the JOINS were removed for the vertical sharding prior to looking at Cloud Spanner. Cloud Spanner fully supports complex JOINS of many times (e.g. INNER, OUTER) Details - https://cloud.google.com/spanner/docs/query-syntax#join-types https://cloud.google.com/spanner/docs/query-syntax#join-type... Disclaimer: I work on Cloud Spanner

koolba 10y ago
Sorry for the confusion but I meant the DML portion.
- MichaelGG 10y ago
  It sounded like you can only modify by primary key? Can you make a transaction that contains a query and a bunch of updates by PK ? And yeah it makes it sound like writing an OEM adapter will be much more difficult.
  - obstinate 10y ago
    From reading the docs, the answer seems to clearly be yes, but I'm open to being corrected.
toadthewet 10y ago
How did you go from 10s of ms for an update for 2012 Spanner, to sub-ms update (best case) for Cloud Spanner according to Quizlet? Did TrueTime get an order of magnitude better? Or is Quizlet measuring the wrong thing?