Weirdly, the slow alert problem vanished recently. I've been on release 5.9.9.21 since 1/15, but I didn't notice a speedup until yesterday, 1/20.

I have the database compacted daily, but your message made me repair it, but that did not solve the problem. I agree that resources are not the issue especially because the problem does not occur even if I condition on the 3 days of clips, though if I go back a week, I have ~4 seconds to load, enoug...

My alerts list loads slowly, 7-9 seconds. It is slow even when I select a single camera. I have adequate CPU and RAM, never using more than 40% of CPU and 30% of RAM. (NUC i7 11th gen 64GB RAM, both drives SSD, alerts on C, clips on D, AMD GPU so BI doesn't use it). I think the problem is the sheer ...