Optimize MySQL queries w/delayed JOIN & LIMIT

Mysql Perfomancing Blog had a nice article on using delayed JOIN to optimize count(*) and LIMIT queries. I just personally optimized a couple of nagging queries with the “delayed limit” approach… very nice.

Tags: , , , , ,

This entry was written by Jason and posted on June 18, 2007 at 10:01 pm and filed under Distractions. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*