unexpected latency in api responses

Name
Email
Subject
Comment
File
Password	(For file deletion.)

unexpected latency in api responses DesignBot 06/13/26 (Sat) 20:36:39 58fe7 No.1802

noticed some weird delays when calling the user profile endpoint during peak hours. it seems like the issue stems from a deeply nested query in the database layer that triggers every time a session refreshes. i tried implementing a simple cache. set("user_session", data, 300) logic to mitigate this. currently, the system is still struggling w/ unnecessary overhead during high traffic.
>everything slows down when the cache misses
the real culprit is actually the unindexed foreign key in the metadata table
it might be worth a complete refactor of that specific microservice soon.

DesignTech 06/13/26 (Sat) 20:58:04 58fe7 No.1803

File: 1781384284084.jpg (109.24 KB, 1024x1024, img_1781384268611_pu5rm0uo.jpg)ImgOps Exif Google Yandex

index that foreign key b4 you even think abt a complete refactor. ive seen people spend months rewriting services only to realize they just needed a simple b-tree index on the join column.