Google翻译API V2的费率限制是多少?(what is the rate limit for Google translate API V2?)
我非常强烈地使用谷歌翻译API V2,在大约2000个请求后,我开始在返回的JSON中得到这个:
Array ( [error] => Array ( [errors] => Array ( [0] => Array ( [domain] => usageLimits [reason] => userRateLimitExceeded [message] => User Rate Limit Exceeded ) ) [code] => 403 [message] => User Rate Limit Exceeded ) )
知道速率限制是什么吗? 你有一个聪明的方法来调节请求率吗?
I am using the Google translate API V2 very intensely and after about 2000 requests I start getting this in the returning JSON:
Array ( [error] => Array ( [errors] => Array ( [0] => Array ( [domain] => usageLimits [reason] => userRateLimitExceeded [message] => User Rate Limit Exceeded ) ) [code] => 403 [message] => User Rate Limit Exceeded ) )
Any idea what the rate limit is? and do you have a smart way of regulating the requests rate?
原文:https://stackoverflow.com/questions/7646112
更新时间:2022-01-18 09:01
最满意答案
尝试这个:
Select SerialNo From ( Select AssetId, SerialNo, 1 as n From AssetMaster Union all Select MainAssetId, SerialNo, 2 as n From ComponentMaster) a Order by AssetId, n, SerialNo
Try this:
Select SerialNo From ( Select AssetId, SerialNo, 1 as n From AssetMaster Union all Select MainAssetId, SerialNo, 2 as n From ComponentMaster) a Order by AssetId, n, SerialNo
相关问答
更多-
您可以使用窗口函数来查找每个sensorname / datetimeid组合的波长数量: WITH Data AS ( SELECT W.DateTimeID, S.SensorName, S.SensorType, W.Channel, W.PeakNr, W.Wavelength, [Wcount] = COUNT(*) OVER(PARTITION B ...
-
SQL Server查询仅从表中获取唯一行,但只获取一次(SQL Server query to get uniques rows only but only once from table)[2022-01-22]
WITH records AS ( SELECT MinPriceID, BasePrice, MinPrice, MinPriceDate, ItemCategoryID, ROW_NUMBER() OVER (PARTITION BY ItemCategoryID ORDER BY MinPriceID DESC) rn FROM TableName ) SELECT MinPriceID, BasePrice, MinPrice, MinPriceDa ... -
SQL Server具有TOP WITH TIES / ROW_NUMBER()技巧,可以非常优雅地执行此操作: SELECT TOP (1) WITH TIES P.FirstName, P.LastName, O.ProductType, PO.ProductName, PO.Quantity FROM Persons P INNER JOIN Orders O ON P.PersonID = O.PersonID INNER JOIN ProductOrders PO ...
-
尝试这个: Select SerialNo From ( Select AssetId, SerialNo, 1 as n From AssetMaster Union all Select MainAssetId, SerialNo, 2 as n From ComponentMaster) a Order by AssetId, n, SerialNo Try this: Select SerialNo From ( Select AssetId, SerialNo, 1 as n F ...
-
您可以使用NOT EXISTS来消除重复: SELECT * FROM yourtable AS T WHERE NOT EXISTS ( SELECT 1 FROM yourtable AS T2 WHERE T.[#] = T2.[#] AND T2.ID > T.ID ); 这将返回: # name ID ------------------ ...
-
select distinct LAST_VALUE(date) over (partition by key1, key2, key3 order by date) date, LAST_VALUE(rate) over (partition by key1, key2, key3 order by date) rate, LAST_VALUE(key1) over (partition by key1, key2, key3 order b ...
-
您可以选择行ID大于/低于当前Id的前1行,因此如果您的Id为123,您可以选择ID大于123的前1行(第1行),而不知道以下内容应该是124.与前一行相同。 因为它的PK应该排序行,所以你不需要添加排序命令。 当然,在询问第一行或后一行之后,你应该注意。 declare @CurrentID int = 123; select top 1 * from [MyTable] where [MyTable].[ID] > @CurrentID; 当然,您最好使用缓存机制来实现它,以避免对每个按钮进行数据库查 ...
-
您可以使用下面的ANSI标准OLAP函数来获得您想要的结果。 SELECT x, min(x) over( ORDER BY id ROWS BETWEEN 1 following AND 1 following) - x AS RESULT FROM table1; 上面的查询通过id对结果进行排序,并从第n + 1行中减去第n行,并将结果与第n行一起显示 示例数据以及结果: x RESULT ----------- ...
-
不,如果没有一些严重的SSMS内部黑客行为,你就无法做到这一点。 您可以选择网格中的所有数据并复制粘贴它。 no, you can't do that without some serious SSMS internals hacking. you can select all data in the grid and copy paste it.
-
无需阅读查询并找到更好的解决方案: SELECT t.NAME_AREA, MAX(t.RESULT_PERSON) AS RESULT_PERSON, MAX(t.RESULT_BOSS) AS RESULT_BOSS FROM ( SELECT AREA.NAME_AREA, (SELECT SUM(ANSWERS.CHOICE * POINTS.POINT / 5) WHERE ANSWERS.TYPE_POLL= 0) AS RESULT_PERSON, (SELECT SUM(ANSWE ...