#9 sguild/sguil.tk active event scalability

[David Wilburn]

Starting up sguild or sguil.tk with more than a few
thousand active events takes extraordinarily long.
Once it's all connected up, it can take almost any load
you can throw at it (millions of alerts per day in
testing), but restarting it then becomes extremely
problematic.

An auto-categorization system would be useful to make
sure that the user consoles don't get flooded out. The
auto-categorization system would have to be running
constantly.

A quick little script to update the status to expired
for all new events would be useful if the system gets
way overloaded, or maybe a command line option to
sguild. This would be necessary if the
auto-categorization system was left not running for too
long as a "break glass in case of fire" kind of thing.
Depending on the autocateogrization system for
everything wouldn't be sufficient.

[Steve Halligan]

Logged In: YES
user_id=688905

AutoCat is in now.
Turning off debug on sguild will make RT events load much
much quicker on a sguild restart.

Between these two things, I don't think we need the update
script, but you can always use mysql to update status if
you want to bulk update.