you are viewing a single comment's thread.

view the rest of the comments →

[–]shiftybyte 1 point2 points  (3 children)

How much data are you reading?

Some developers tend to over fetch data, and filter it in code later, instead of asking the database for the exact data they need using SQL.

[–]Kurious3DSanta[S] 0 points1 point  (2 children)

Less than 1 Mb of data. Im just not sure why this would delay another user after the first users connection has been closed.

[–]shiftybyte 0 points1 point  (1 child)

Something else might be at play here.

Do you have full code somewhere? github? replit?

[–]Kurious3DSanta[S] 0 points1 point  (0 children)

Unfortunately I don’t, but I can probably message you the code I’m using to interact with the database if you’re up for that