Participant Report Speed Up

Fast RonYou may have noticed a speed up in the Participant Reports on your race dashboard. We did some optimizations of the queries as part of our infrastructure upgrades. We are also benefiting from the upgrade we made to the Aurora Database yesterday.

The database upgrade is probably not noticeable to the human eye. Individual database operations improved about 10-20%, however we are talking improvements from 75 milliseconds to 68 milliseconds, and 185 milliseconds to 152 milliseconds, and from 12.5 milliseconds to 11.5 milliseconds (there are 1,000 milliseconds in a seconds). But little changes like this can add up.

The query optimization was more important to the Participant Report, probably saving a half second to second. The first query of your participants (even with races with 20,000+ participants) should now be under 2 seconds and subsequent queries will be sub-second with fast internet and a decent browser and computer.

Author: RunSignUp

RunSignUp is the leading innovator of online tools for race registration, race day solutions, and running clubs. Services include RunSignUp for registration, RunSignUp Go for Race Day, RunSignUp RD Go for Timers, RunSignUp Clubs to enable membership management, and RaceJoy for mobile experiences. More than 10,000 race directors, timers, running club officers and running stores use these services today, including leading organizations like the Boilermaker Road Race, Crim Festival of Races, Pittsburgh Three Rivers Marathon, Inc., Fifth Third River Bank Run, Blacklight Run, Bubble Run, Night Nation, Mercedes Marathon, Kentucky Derby Festival, Leone Timing, KC Running Company, Compuscore Timing, Knoxville Track Club, Pikes Peak Road Runners, Gulf Coast Runners, Columbus Running Company, Playmakers Running Store and many more. In 2015, over 10,000 races used the system to register more than 2.7 million participants. In 2016 over 14,000 races will use the system to process over 4.3 million paid registrations. Services are free except for processing fees when conducting monetary transactions such as race registration or club membership renewal. RunSignUp is founded by runners for runners, using technical capabilities to bring the power of cloud computing to benefit the running community. For more information, visit www.RunSignUp.com.

1 thought on “Participant Report Speed Up”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s