Alerts feature overwhelmed by "dust storm deposits"

[hutchwilco]

Unsure if this is affecting many others, but due to the dust storm of "thousands of Cha-ching! Just received 0.000000000001 XCH" deposits in recent weeks, the Alerts page is getting bogged down trying to load ~15,000 entries, and sort them into pages of 10 per page.

Can I suggest a method be provided for users to go into the database and query that term and remove?

Thanks!

[guydavis]

Hi, have not seen that, but here's the SQL:

[hutchwilco]

thank you! this removed ~14,500 entries from the dust storm deposits