diff options
| author | fisharebest <fisharebest@gmail.com> | 2011-03-07 21:48:01 +0000 |
|---|---|---|
| committer | fisharebest <fisharebest@gmail.com> | 2011-03-07 21:48:01 +0000 |
| commit | c332f1304fc61e95630fe4dd7630fa55c1be8795 (patch) | |
| tree | 2c2333e458625efc49b452afc6f118e5e3577b7f /setup.php | |
| parent | 8e40b1a25b4f1fc3693232d628ea3ec3647967a0 (diff) | |
| download | webtrees-c332f1304fc61e95630fe4dd7630fa55c1be8795.tar.gz webtrees-c332f1304fc61e95630fe4dd7630fa55c1be8795.tar.bz2 webtrees-c332f1304fc61e95630fe4dd7630fa55c1be8795.zip | |
Performance: rewrite INDILIST and FAMLIST queries to use new indexes on n_surn and n_givn columns.
Diffstat (limited to 'setup.php')
| -rw-r--r-- | setup.php | 5 |
1 files changed, 3 insertions, 2 deletions
@@ -847,7 +847,8 @@ try { " n_soundex_surn_dm VARCHAR(255) NULL,". " PRIMARY KEY (n_id, n_file, n_num),". " KEY ix1 (n_full, n_id, n_file),". - " KEY ix2 (n_file, n_surn)". + " KEY ix2 (n_surn, n_file, n_type, n_id),". + " KEY ix3 (n_givn, n_file, n_type, n_id)". ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); $dbh->exec( @@ -962,7 +963,7 @@ try { ); $dbh->exec( "INSERT IGNORE INTO `{$TBLPREFIX}site_setting` (setting_name, setting_value) VALUES ". - "('WT_SCHEMA_VERSION', '9'),". + "('WT_SCHEMA_VERSION', '10'),". "('INDEX_DIRECTORY', 'data/'),". "('STORE_MESSAGES', '1'),". "('USE_REGISTRATION_MODULE', '1'),". |