Add index on {taxonomy_term_data}.name column to speed up taxonomy_get_term_by_name().
function taxonomy_update_7007() { db_add_index('taxonomy_term_data', 'name', array( 'name', )); }