Speeding up Views 2? How can I speed up my complex views? I don't want to remove functionality from my views to speed them up. Some of my views have 5 lefts joins. Is there anything I can do to optimize these queries? 

Here's an example: http://i27.lulzimg.com/214ce7e242.png

Here's another one: http://i27.lulzimg.com/5c1d52ab2d.png
You can try installing DB Tuner and/or run mysqltuner.pl and experiment with the suggestions.

Edit to address the comments.

In addition to trying to optimize the database itself, you can also copy/paste the SQL that Views generates and run the query manually with an EXPLAIN.  This may shed some light on why the query is taking a while to run.  You can then edit the view as needed, and potentially add some indexes that the above tools may not have identified.