@xpilar reported a problem two days ago:
I checked that the underlying problem is the API took longer time expected to complete which resulted in Tool not working properly.
The Tool queries the SQLite DB for the downvote records in the last 365 days.
Despite that I have slightly improved the SQL - but it may sometimes timeout due to the performance.
The SQLite is not ideal - which should really be replaced by MySQL or Posgres which are better in performance.
The SQLite DB is not suitable for multithreading.
And it may throw "sqlite3.OperationalError: database is locked" error when multiple threads are executing SQL on the same Table/DB.
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!