Warning: This whole thread is only about historical information now since it's 2018 and we can buy inexpensive and great performing A1 rated SD cards in the meantime. Buying anything else is a mistake so directly jump to the end of the thread for performance numbers and recommendations.
Edit: See an early 2017 update at the end of the thread regarding new SD specs also covering random IO performance.
Edit 2: Some thoughts/observations on lifespan/reliability