search

Dsek-LTH / web

The D-guild's primary web page
https://dsek.se
European Union Public License 1.2
22 stars 9 forks source link

Investigate performance bottlenecks #554

Closed danieladugyan closed 1 week ago

danieladugyan commented 3 weeks ago

Background

We tried building a ticket system for selling tickets to nollor/phaddrar during the introduction period. Unfortunately it crashed immediately under load making it completely unusable.

To-do

Begin by investigating what is slowing down our application, for instance using tracing.

Original issue

This image is a quite accurate illustration of how we currently interact with the database. Unfortunately it's titled with "don't do this"... Image

Expected follow up: Read through this guide on how you should query the database in SvelteKit. Restructure the application to follow the recommended approaches.

See also: https://www.captaincodeman.com/securing-your-sveltekit-app

danieladugyan commented 1 week ago

After doing some investigation here it's still not entirely clear why the application performs poorly. Possible culprits are slow server hooks, poor database performance and blocking load functions.