this post was submitted on 04 Dec 2023
94 points (98.0% liked)
pics
24313 readers
444 users here now
Rules:
1.. Please mark original photos with [OC] in the title if you're the photographer
2..Pictures containing a politician from any country or planet are prohibited, this is a community voted on rule.
3.. Image must be a photograph, no AI or digital art.
4.. No NSFW/Cosplay/Spam/Trolling images.
5.. Be civil. No racism or bigotry.
Photo of the Week Rule(s):
1.. On Fridays, the most upvoted original, marked [OC], photo posted between Friday and Thursday will be the next week's banner and featured photo.
2.. The weekly photos will be saved for an end of the year run off.
Instance-wide rules always apply. https://mastodon.world/about
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
That sounds like a possible race condition when multiple requests are executing at the same time. Without knowing anything about the design, perhaps you could look into database transactions. You could also look into generating load via jmeter, but then we wouldn't get a picture.
Using SQLite seems to have solved it, but it's still bogged down by disk IO speeds. The only way I can induce errors right now is with benchmark tools, and that'll be solved if I use an in-memory DB hopefully.