Rider comparison feature re-worked

Much improved - support for many more riders at once

By Seb Frost5:45pm, Jan 29th 2010

The rider comparison page used to be near-instant with 2 riders. 2-5 seconds with 3 riders, and a 30-second crash with 4 riders. Hence I had to lock it to a max of 3 riders... not so any more.

OK, big improvement today.

I worked out a much more efficient way of querying the database, and now even ten riders is near-instant, MUCH better.

Example: http://www.rootsandrain.co.uk/compare.html?i=331x211x332x759x790&year=2009

I'm not done yet though, there's still a lot that can be done to improve it...

One thing that would definitely be beneficial would be to somehow show races which not everyone has been in. So if you select 6 riders it shows all the races that at least 2 of them have done, and then groups the most "complete" races together at the top. Otherwise when you add in 10 riders you end up with only 1 or 2 races showing.