使用Fusion Tables有哪些技术限制? [英] What are the technical limitations when using Fusion Tables?

问题描述

我正在寻找有关使用Fusion Tables的技术限制的信息:--Fusion Table中可以存储多少行 -可对Fusion Table同时执行多少个查询(读/写). 我在 https://developers.google.com 上找不到任何信息. 我问了一位Google代表，他告诉我Fusion Tables仍然是实验性/测试版产品，我将在stackoverflow上进行检查.

我计划开发一个应用程序，用户可以在其中更新特定位置的属性.我想使用Fusion Tables，以便将位置及其属性存储在Fusion Table中. 该应用程序将涉及表的大量读取/更新(在一分钟内最多可进行500 000次读取/更新查询)，并且在Fusion Table中最多可注册300万个位置，因此我想知道是否会受到技术的限制，技术上或服务条款方面.

我的印象是，Fusion Tables确实不应该以如此高的频率进行更新.

解决方案

要考虑许多限制:

每天
• 每天25,000个请求
每个表
• 250 MB空间
• Fusion Tables中的数据单元格最多支持100万个字符
• 插入限制
  • 单个HTTP请求的最大数据大小为1MB
  • 要添加的表单元格总数不能超过10,000个单元格(不是行！)
  • 单个请求最多可以包含500个INSERT语句
• 仅前100,000条记录被映射或包含在空间查询结果中
• 在地图上查看时，地图图块可能会超出每瓦片500个要素的限制，并且要素将从地图上删除

请注意，文档的不推荐使用的部分中介绍了上述最后两个限制，找不到关于它的更新文档.该限制可能不再存在，或者尚未被记录.但是，如果您使用 FusionTablesLayer 在Google Maps上显示数据，这些限制肯定适用. >

FusionTablesLayer限制:

• 最大每张地图5层
• 只能将样式应用于其中之一
• 最大该图层可以应用5种样式
• 表中仅前100,000行的数据被映射或包含在查询结果中
• 地图图块可能会超出每区块500个特征的限制，并且地图项将被删除

如果您是 Google Maps Premier 客户，则可以修改某些限制.

>

I am looking for information regarding the technical limitations when using Fusion Tables : - - how many rows can be stored in a Fusion Table - how many queries (read/write) can be run simultaneously against a Fusion Table. I could not find any info on https://developers.google.com I asked a Google representative and he told me that Fusion Tables is still an experimental / beta product, and I shall check out at stackoverflow.

I plan to develop an application where users will update attributes of specific locations. I would like to use Fusion Tables so that locations and their attributes are stored in a Fusion Table. The application will involve a lot of read/updates of the table (up to 500 000 read/update queries in one minute), with up to 3 000 000 locations registered in the Fusion Table so I wonder if I will be limited by the technology, technically or regarding the terms of service.

My impression is that Fusion Tables are not really supposed to be updated with such a high frequency.

解决方案

There are a number of limitations to consider:

• 25,000 requests/day
• 250MB space per table
• A cell of data in Fusion Tables supports a maximum of 1 million characters
• Insert Limits
  • Maximum data size for a single HTTP request is 1MB
  • Total number of table cells being added cannot exceed 10,000 cells (not rows!)
  • A single request may contain up to a maximum of 500 INSERT statements
• Only the first 100,000 records are mapped or included in spatial query results
• When viewed on a map, map tiles may exceed the 500 feature-per-tile limit, and features will be dropped from the map

Please note that the last two limits above are described in a deprecated section of the documentation, I couldn't find newer documentation about it. Maybe the limit does no longer exist or it just has not yet been documented. But the limits certainly apply if you are using FusionTablesLayer to to display data on Google Maps.

FusionTablesLayer limits:

• Max. 5 layers per map
• Only to one of those layers styles can be applied
• Max. 5 styles may be applied on this layer
• Only the first 100,000 rows of data in a table are mapped or included in query results
• Map tiles may exceed the 500 feature-per-tile limit, and features will be dropped from the map

If you are a Google Maps Premier customer, some of the limits can be modified.

这篇关于使用Fusion Tables有哪些技术限制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！