I already had switched on the debugging: attached the output of index.php.
edit: I am not able to attach it - a file with the zipped queries of index.php is 416 kb big - where can I email it to?
Chuck: no it is not good - it should be far less then one second, especially if it a part of it already is cached. I just checked vbulletin - the index there currently loads in less then a second and our forums also have 50K users, > 2000K posts etc. Asides from this I measured the performance around midnight - without any traffic involved...
queries2.txt - the queries for http://fotos.mtb-news.de/fotos/showp...71/limit/views
(contains the same query twice! see 4 and 5)
Perhaps some limits would do good here to avoid transferring huge amounts of data from db to webserver.
We already went through the same thing after the last upgrade - please see the third post on this page and Michaels post on the same page: http://www.photopost.com/members/for...ighlight=debug
after these discussions and updated files we went down under 1 sec for the index with pp 502 without any altered file
Thanks for your help