BigQuery需要很长时间才能从GWT执行查询 [英] BigQuery query execution from GWT taking very long time

问题描述

我们正在使用BigQuery与我们的GWT应用程序和Google APP引擎。
查询执行（来自应用程序）需要很长时间，例如4到5秒钟。
表格中不超过200行。这个延迟影响了整个应用程序的性能。

查询由where和groupby子句组成。

是否提前致谢

解决方案

BigQuery不是为200行的表设计的。它总是需要几秒钟才能得到答案。当您想要分析数十亿行时，BigQuery是一项资产。

在此大小下，您最好使用更传统的数据存储解决方案，例如Cloud SQL或App Engine数据存储。

如果您想保留SQL功能，Cloud SQL是最好的选择。

We are using BigQuery with our GWT application and Google APP engine. The query execution ,( from the application) is taking very long time like 4 to 5 seconds. There are no more than 200 rows in table. This latency is effecting the whole performance of the application.

The query consists of where and groupby clauses.

Is there any way that the bigquery execution can be optimized to improve the performance.

thank in advance.

解决方案

BigQuery is not designed for tables with 200 rows. It will always take several seconds to get the answer. BigQuery is an asset when you want to analyze billions of rows.

Under this size, you'll be better off using more traditional data storage solutions such as Cloud SQL or the App Engine Datastore.

If you want to keep SQL capability, Cloud SQL is the best guess.

这篇关于BigQuery需要很长时间才能从GWT执行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！