I have made a photo gallery for tenbit.pl. It provides extend user profile, categories and voting.
We have around 2 milions page views per day. This can only work with great focus on optymalization (database query, indexes and cache).

Url: http://galeria.tenbit.pl/