Changes between Version 33 and Version 34 of InstallationGuidelines/MySQL
- Timestamp:
- 09/06/10 09:59:17 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v33 v34 62 62 }}} 63 63 64 Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns ]:64 Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns, however most of the time this field is unique & so indexed automatically]: 65 65 * gis_location.name 66 66 * pr_person.first_name … … 69 69 70 70 {{{ 71 ALTER TABLE `gis_location` ADD INDEX ( `name`);72 ALTER TABLE `pr_person` ADD INDEX ( `first_name`);73 ALTER TABLE `pr_person` ADD INDEX ( `middle_name`);74 ALTER TABLE `pr_person` ADD INDEX ( `last_name`);71 CREATE INDEX name__idx on gis_location(name); 72 CREATE INDEX first_name__idx on gis_location(first_name); 73 CREATE INDEX middle_name__idx on gis_location(middle_name); 74 CREATE INDEX last_name__idx on gis_location(last_name); 75 75 }}} 76 76 77 @ToDo: Add these to {{{models/zzz_1st_run.py}}} 77 These should already be done automatically by {{{models/zzz_1st_run.py}}} 78 78 == Troubleshooting == 79 79 Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding:
