somehow this all didn't really help - we decided to rewrite showphoto.php with an emphasis on the performance side. we enabled the new version yesterday around 18:00 - see the image attached for the result.
Page generation time also went down from 1.xx or 2.xx seconds to 0.02 - 0.05 seconds
Example:
http://fotos.mtb-news.de/fotos/showp...71/limit/views
Stats:
Pictures 161.000 Comments: 195.000