BigQuery Performance

Question

Is there a way to stabilize the response time of requests? For example, these two tasks that perform the same request have different response times:

JobId: job_gzTkFvGculpLw0tQRMZvj6rskMI Request time: 00: 00: 09.2827336

JobId: job_9wXD9ONxDoI87lD6lOXZJSEM1aE Request time: 00: 00: 28.1064037

Why does the same request have very different response times?

** EDIT: ProjectId - nostrum.eu:nostrum

Answer 1

By default, BigQuery uses Query caching to speed up response time for general queries that can be used multiple times.

, , .

, , API:

{
  "kind": "bigquery#queryRequest",
  "query": query,
  "defaultDataset": {
    "datasetId": string,
    "projectId": string
  },
  "useQueryCache": False
}

, , , , , .

Answer 2

BigQuery . - ( ), , ( BQ ).

, BigQuery , , . . , .

https://developers.google.com/bigquery/pricing#reserved_cap