Downvote Tool Fixed: SQL Improved
@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!
!thumbup !test
!ask How to solve "sqlite3.OperationalError: database is locked"
1. Close all connections to the database
2. Check if any application is using the database file
3. Use the PRAGMA busy_timeout statement to set a timeout for the database connection
4. If step 3 does not work, restart your application or computer
5. If step 4 does not work, use the SQLite Wal-mode feature to enable read access while another process is writing to the database.
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
Hello @justyy! You are Fabulous!
command: !thumbup is powered by witness @justyy and his contributions are: https://steemyy.com
More commands are coming!