My wordpress site produced 673 queries and I think it came from listing all of my 600+ categories. Is there a way to reduce the queries? I already have wp super cache plugin
I mean mysql queries. You can check it here http://www.lovelyanime.com/full-anime-series-list/ you can check the view source and it tells you that it did <!-- 673 queries. 1.154 seconds. -->
Hey forget about super cache, use hyper cache! It's better! I had same problem earlier, but now with hyper cache it's solved! http://www.satollo.com/english/wordpress/hyper-cache
I recommend you to get http://wordpress.org/extend/plugins/wptuner/ You will see which plugin is causing you problems.
Currently my blog has 30-40 queries per page. 673 is really HUGE for normal server. try to use less numbers of Plugins, disable and delete unused plugins. I can help u in this matter in detailed, cause i was having same problem.
Like I said I can't use TAGS cause it doesn't support descriptions! I already deleted all the unused plugins but that didn't decrease the queries
If you have a lot of categories, you should change the queries of wp_list_categories(); into static html.