Hello 👋
Worked on improving the speed of updating a comment status from default to "retracted" and vice versa. It was a time sink tracking what specific parts of the program are actually slow. One of the reasons (maybe?) why my program slow was because of the frequent reconnection-disconnection to my db which was solved by putting initializing the db part to a separate script. Simple fix. Next, I forget to set SQLite to PRAGMA journal_mode = WAL. Very important for write heavy stuff.
Anyways, that's all. CiaoooOOO!
Top comments (0)