DEV Community

Isaiah
Isaiah

Posted on

1 1 1

#100DAYSOFCODE: Day 11

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)

Cloudinary image

Video API: manage, encode, and optimize for any device, channel or network condition. Deliver branded video experiences in minutes and get deep engagement insights.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay