Transients are an excellent way to speed up complex queries in WordPress. Dave Clements shows you in this post how you can use transients to avoid bringing a site to its knees like he did, by caching those queries instead of repeating them on every page load.