diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-09-13 01:07:45 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-09-13 01:07:45 +0000 |
| commit | 6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12 (patch) | |
| tree | 9a9982616eb55cbcc353207521c370d0c1dad16b /Changelog-Trunk.txt | |
| parent | ef2ebfc6da2dac054af7dfe206bf1ea9906435ea (diff) | |
| download | hercules-6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12.tar.gz hercules-6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12.tar.bz2 hercules-6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12.tar.xz hercules-6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12.zip | |
- Modified the login SQL server so that case insensitive lookups use "where name = BINARY 'name'" instead of "where BINARY name = 'name'", since this way the name index should be used, and performance will no longer be heavily affected.
- Modified main.sql to add 4 missing indexes (thanks to ErkDog): char_id on the tables memo/friends, and online/name on the char table. Added upgrade_svn8728.sql to add these indexes to already existing tables.
- Changed back the default of case-sensitive to ON since it shouldn't be such a bad performance hog now.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8728 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'Changelog-Trunk.txt')
| -rw-r--r-- | Changelog-Trunk.txt | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index 8e5358c99..6517c3a69 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -4,6 +4,14 @@ AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.
2006/09/12
+ * Modified the login SQL server so that case insensitive lookups use "where
+ name = BINARY 'name'" instead of "where BINARY name = 'name'", since this
+ way the name index should be used, and performance will no longer be
+ heavily affected. [Skotlex]
+ * Modified main.sql to add 4 missing indexes (thanks to ErkDog): char_id on
+ the tables memo/friends, and online/name on the char table. Added
+ upgrade_svn8728.sql to add these indexes to already existing tables.
+ [Skotlex]
* Updated convert_engine.sql to use TYPE instead of ENGINE to be compatible
with Mysql 4 installations. [Skotlex]
* Moved the morph restrictions from skill_additional_effect to
|