Improve indexes on the {url_alias} table.

Related topics

File

drupal-6.x/modules/system/system.install, line 2730

Code

function system_update_6055() {
  $ret = array();
  db_drop_index($ret, 'url_alias', 'src_language');
  db_drop_unique_key($ret, 'url_alias', 'dst_language');
  db_add_index($ret, 'url_alias', 'src_language_pid', array('src', 'language', 'pid'));
  db_add_unique_key($ret, 'url_alias', 'dst_language_pid', array('dst', 'language', 'pid'));
  return $ret;
}