在 Google AppEngine 中使用分片计数器存储每小时的点击次数

发布于 2024-11-28 01:54:47 字数 582 浏览 2 评论 0原文

我正在为谷歌应用程序引擎开发一个Python应用程序，它使用分片计数器来计算不同类型的点击。

我的问题是我想获得按小时划分的点击次数统计数据，而不仅仅是所有点击次数的总和。

实现这一目标的一种方法是向分片索引添加时间戳：

def txn():
  index = random.randint(0, config.num_shards - 1)
  shard_name = code + str(index) # + timestamp without seconds
  counter = ClickCounter.get_by_key_name(shard_name)
  if counter is None:
    counter = ClickCounter(key_name=shard_name, code=code)
  counter.click += 1
  counter.put()
db.run_in_transaction(txn)

问题是计算一个月内的所有分片会慢 700 倍以上。

有没有好的方法来缓存结果？我的意思是，一旦过了一个小时，计数器就不会再改变了。将每次点击保存在新对象中是否有缺点？

原文

I'm developing an app in python for google app engine that count different kind of clicks with sharded counters.

My problem is that I want to get statistics split by hour from the clicks and not just a total sum of all clicks.

One way to achieve that is to add a timestamp to the index of the shards:

def txn():
  index = random.randint(0, config.num_shards - 1)
  shard_name = code + str(index) # + timestamp without seconds
  counter = ClickCounter.get_by_key_name(shard_name)
  if counter is None:
    counter = ClickCounter(key_name=shard_name, code=code)
  counter.click += 1
  counter.put()
db.run_in_transaction(txn)

The problem would be that counting all the shards for a month would be more than 700 times slower.

Is there a good way to cache the results? I mean, once an hour has passed the counter won't change any more. Is there a drawback with saving every click in a new object?

分享到QQ

分享到微博