Some Advices to Improve the Slow Queries (Recent Steemit Crash Incidence)

in #steemlast year (edited)

The recent downtime of SteemIt UI (Condenser) is due to two slow APIs that impacted the hivemind server. According to @ety001

image.png

Currently, the service has resumed normal (it seems, but sometimes page takes time to load), but this is not the first time that the steemit site is down due to the same reason.

Here are a few suggestions that we can try:

  1. seek ways to improve the efficiency of those two queries e.g. add proper caching/indices
  2. isolate the APIs to not to impact the whole sites
  3. seek alternatives to replace the slow APIs (deprecate them)
  4. upgrade hardware (e.g. SSD/NVme)

Steem to the Moon🚀!

  • You can swap the STEEM/SBD to Tether USDT (TRC-20) via steem2usdt!
  • You can swap the STEEM/SBD to TRX (TRON) via steem2trx!
  • You can swap the STEEM/SBD to BTS (BitShares) via steem2bts!
  • Register a free STEEM account at SteemYY!
Sort:  

!ask who owns the steem blockchain?



The Steem blockchain is owned and operated by the Steemit Inc. community, a company founded by Ned Scott and Dan Larimer.


command: !ask is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!. !ask is currently based on ChatGPT-3.5

!test !thumbup

Hello @justyy! You are Brilliant!


command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!

Hi @justyy it looks like Steemit is still down today. I am getting “gateway time out 504”😲
Upvu. Org is still working 😊

Coin Marketplace

STEEM 0.18
TRX 0.16
JST 0.030
BTC 78880.92
ETH 3188.85
USDT 1.00
SBD 2.68