This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Delay in result when running a query via SDK

Posted on 06-24-2024 04:11 AM
sharontmathew
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

If the query is run on the BQ editor, I get the results in 2 seconds. But if I run the query via SDK(7.7.1), I get the results in 18 seconds, which is a huge delay. 
How can I increase the performance of the SDK when running the Query. What is the reason behind this delay in getting the output.

0 2 294
Topic Labels
0 Likes
Reply
2 REPLIES 2

Posted on --/--/---- --:-- AM
jaia
Staff
Reply posted on --/--/---- --:-- AM

Hello,

Thank you for contacting Google Cloud Community!

The SDK handles things like authentication, request/response marshalling, and potential retries in case of errors. This can add a few seconds to the overall query execution time.
Please check for newer versions of the BigQuery SDK. You can find the latest version information in the official documentation. Upgrading result in performance improvements or bug fixes related to your specific version.

Regards,
Jai Ade

Reply

Posted on --/--/---- --:-- AM
jaia
Staff
Reply posted on --/--/---- --:-- AM

Hello,

Thank you for your engagement regarding this issue. We haven’t heard back from you regarding this issue for sometime now. Hence, I'm going to close this issue which will no longer be monitored. However, if you have any new issues, Please don’t hesitate to create a new issue. We will be happy to assist you on the same.

Regards,
Jai Ade

Reply
Top Solution Authors
View all