Can we please default the dates on the input dialog box to something like:

From: 1 Week Ago
To: Today

Seems trivial to do this yourself when on the page but it has two benefits:

1. Makes a quick run a single click operation.
2. Reduces likelihood of anyone going back months for the sake of it.

Utilise Svelte's component model more heavily by breaking up big components into smaller ones therefore making the code more tidy, readable and maintainable.

QueryAsync<T> with the following SQL which is inside SelectPingsByDateAsync takes 4s to complete when run against the whole dataset despite taking only 0.33s in MySQL console with the same parameters.

SELECT server.serverId, server.serverName, pings.pingTime, pings.playersOnline
FROM pings
INNER JOIN server ON pings.serverId = server.serverId
WHERE pingTime >= @fromDate and pingTime <= @toDate
ORDER BY pings.pingTime;

Method in question: