Email or username:

Password:

Forgot your password?
Alex Gleason
Yess, finally got remote profiling working so I can figure out why my shit is so fucked. I am really using the Chrome inspector to profile my Deno backend code over an SSH tunnel.
4 comments
Alex Gleason
Well, there's the problem. 4 seconds for a single tick.
Alex Gleason
Shit man, maybe the database actually is the bottleneck 🥲
Alex Gleason
Okay, I think I understand what's happening. I render a page of 20 statuses. For each status I query the author as a separate query. This results in 20 additional queries. I need to make my views pure functions, query all the data up-front and pass them in.

God I love this. So glad I finally got this set up.
Alex Gleason
It wouldn't hurt to also put SQLite into a Web Worker.
Go Up