[Notice] Optimized the bridge.get_ranked_posts API | 优化了 bridge.get_ranked_posts 接口
Today, an optimization scheme has been deployed.
This optimization scheme involves the API of bridge.get_ranked_posts.
On the UI, it is reflected in the increased display speed of the trending category of each community on the homepage.
The optimization idea is to change the full-table scan to only scan past 7 days' posts.
According to the current UI design and the product logic of this API, the data volume of posts from 7 days is sufficient.
The code will be in trial operation for a period of time.
After there are no problems, it will be merged into the main branch.
If you have any issue, feel free to message me on here or Discord.
Thank you for reading. I'm a witness. I would really appreciate your witness vote! You can vote by SteemLogin. Or open https://steemitwallet.com/~witnesses page, input ety001 to vote.
今天部署了一个优化方案。
该优化方案涉及到 bridge.get_ranked_posts 接口。
优化后，首页各个 community 的 trending 分类展示速度得到大幅度的提升。
优化思路是：把过去全表扫描改为了只扫描过去7天的posts。
根据目前 UI 的设计，以及该接口的产品逻辑，使用 7 天的 posts 数据量是足够的。
代码将会试运行一段时间，没有问题后会合并到主干。
如果有疑问，随时可以给我留言。
ET碎碎念，每周更新，欢迎订阅，点赞，转发！
好用不贵的VPS推荐
感谢你的阅读，我是中文区见证人之一，欢迎通过 AuthSteem 来给我投票，或者打开 https://steemitwallet.com/~witnesses 页面，输入 ety001 进行投票。
中文区的见证人目前有：
支持一下他们（按字母顺序），一人可以有30票：
This post has been featured in the latest edition of Steem News...
"🎉 Great job on deploying this optimization scheme! It's awesome to see improvements like increased display speed for trending categories on the homepage 📈. Kudos to you and your team for working hard to enhance user experience 😊.
I'm curious, how will this change impact users in terms of post visibility and engagement? Are there any plans to roll out similar optimizations for other Steem features? 🤔
Also, I'd love to give a shoutout to all the witnesses supporting the Chinese community! Keep up the great work 🙌.
P.S. If you haven't already, please consider voting for xpilar.witness by heading over to https://steemitwallet.com/~witnesses - your support means a lot! 💕"