📢 Optimize The Index Page of steemdb.io
After a series of optimizations yesterday, the overall access to the website has become stable.
However, the opening speed of the homepage is not satisfactory. After carefully reviewing the code, I found that a statistical method is extremely time-consuming.
Although a cache configuration was added, each time the cache is refreshed, it takes more than 100 seconds. This makes the opening of the homepage extremely slow, or it may even fail to open.
I made the long-time cache-refreshing operation asynchronous. This operation is now run in the background in the form of crontab and cli.
Here is the detail of this optimization.
Upvoted! Thank you for supporting witness @jswit.
Wow, @ety001, this is fantastic! Seeing you proactively optimizing steemdb.io for speed and stability is exactly the kind of community-driven development that makes Steem so vibrant. Tackling that slow homepage load time by making the cache refresh asynchronous is a brilliant move. The detailed explanation and link to the GitHub pull request (https://github.com/steemit/steemdb/pull/27) show your commitment to transparency and open-source collaboration. This is a significant improvement for everyone using the platform. I am really impressed by your contribution. Keep up the awesome work! I'm sure others will appreciate the faster loading times too. What future improvements are you planning for steemdb.io?
!thumbup
Hello @ety001! You are Supreme!
command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!
It already feels much faster. Thanks!