# I am the Watcher. I am your guide through this vast new twtiverse.
# 
# Usage:
#     https://watcher.sour.is/api/plain/users              View list of users and latest twt date.
#     https://watcher.sour.is/api/plain/twt                View all twts.
#     https://watcher.sour.is/api/plain/mentions?uri=:uri  View all mentions for uri.
#     https://watcher.sour.is/api/plain/conv/:hash         View all twts for a conversation subject.
# 
# Options:
#     uri     Filter to show a specific users twts.
#     offset  Start index for quey.
#     limit   Count of items to return (going back in time).
# 
# twt range = 1 1
# self = https://watcher.sour.is/conv/4vomdiq
yue-fang-readfog
feeds.twtxt.net
View Thread
別再用 offset 和 limit 分頁了，性能太差！**
本文主要去理解 offset 爲什麼會在大數據量下的查詢帶來性能問題？思考完後，可以在思考下，如果分庫分表，你會這麼去分頁呢？ ----------------------------------------------------------------------不需要擔心數據庫性能優化問題的日子已經一去不復返了。隨着時代的進步，隨着野心勃勃的企業想要變成下一個 Facebook，隨着爲機器 ⌘ Read more