René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Query performance optimizations","articleBody":"This issue tracks the \"fast query path\" changes for the Python client(s):\r\n\r\n- [x] https://github.com/googleapis/python-bigquery/pull/363 -- Update `QueryJob` to use `getQueryResults` in `RowIterator`. Project down to avoid fetching schema and other unnecessary job stats in `RowIterator`.\r\n- [x] https://github.com/googleapis/python-bigquery/pull/374 -- Update `QueryJob` and `RowIterator` to cache the first page of results, which we fetch as part of the logic to wait for the job to finish. Discard the cache if `maxResults` or `startIndex` are set.\r\n- [x] https://github.com/googleapis/python-bigquery/pull/375 -- Update DB-API to avoid direct call to list_rows()\r\n- [x] https://github.com/googleapis/python-bigquery/pull/384 -- Update `to_dataframe` and related methods in RowIterator to not call BQ Storage API if cached results are the only page.\r\n- [ ] Update DB-API to not call BQ Storage API if cached results are the only page.\r\n- [ ] Update Client.query to call jobs.query backend API method for acceptable `job_config`s.\r\n- [ ] (optional?) Avoid call to jobs.get in certain cases, such as `QueryJob.to_dataframe` and `QueryJob.to_arrow`\r\n  - Add \"reload\" argument to QueryJob.result() -- default to True.\r\n  - Update RowIterator to call get_job to fetch the destination table ID before attempting use of BQ Storage API (if destination table ID isn't available).\r\n","author":{"url":"https://github.com/tswast","@type":"Person","name":"tswast"},"datePublished":"2020-11-03T20:36:58.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/362/python-bigquery/issues/362"}