[Task]: Debug intermittent excess load placed on SQlite DB by excess queries

[lxmcgvrn]

Description

While working with @danbarr he noticed some DB locks while using the dashboard normally.
It looked like there are probably a few things going on here:

• excess reads from the frontend — there may be opportunities to more heavily leverage cache
• long reads due to no pagination on the server — Dan's got a lot of messages & alerts locally

Additional Context

No response

[lxmcgvrn]

I investigated this, using @tanstack/react-query-devtools — there doesn't seem to be a very excessive number of queries being triggered from the frontend (like we saw in the past).

It seems this issue is related to the number of records present on his machine, which will be adressed in the future by pagination.

I've tracked this separately here: stacklok/codegate#1020