Stan’s Obligatory Blog

Happy Halloween

4/9/2010

Another milestone for my Pet Project

Filed under: — stan @ 6:56 am

Last summer, I was very pleased to see when the Earthquake Notification Service passed 150,000 subscribers. On average about 30-50 people sign up for it every day, and more after each large earthquake. And this week’s M7.2 Baja California earthquake pushed it over the top to more than 200,000 subscribers.

The earthquake also set a new record for the amount of mail sent in one day. The previous record of 2,326,000 messages was set after the M8.8 Chile earthquake in February. But this earthquake blew right past that record with 4,508,522 messages sent. And it would have been more if the database problems hadn’t slowed the system to a crawl. At the end of the first day, there were over 600,000 messages waiting to be sent, and over 500 earthquakes waiting to be processed.

Fortunately, I’ve found a workaround to keep the system from getting slow while processing large numbers of earthquakes, and I’m working on a re-architecture of the database to be able to handle heavier loads in the future.

Powered by WordPress