From 6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12 Mon Sep 17 00:00:00 2001 From: skotlex Date: Wed, 13 Sep 2006 01:07:45 +0000 Subject: - 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 --- conf-tmpl/Changelog.txt | 2 ++ conf-tmpl/login_athena.conf | 5 +---- 2 files changed, 3 insertions(+), 4 deletions(-) (limited to 'conf-tmpl') diff --git a/conf-tmpl/Changelog.txt b/conf-tmpl/Changelog.txt index aa1c380ea..4499d63cb 100644 --- a/conf-tmpl/Changelog.txt +++ b/conf-tmpl/Changelog.txt @@ -1,6 +1,8 @@ Date Added 2006/09/12 + * Changed back the default of case-sensitive to ON since it shouldn't be + such a bad performance hog now. [Skotlex] * case_sensitive is now off by default due to performance issues (login_athena.conf). [Skotlex] 2006/09/11 diff --git a/conf-tmpl/login_athena.conf b/conf-tmpl/login_athena.conf index beb6b6169..41995a2db 100644 --- a/conf-tmpl/login_athena.conf +++ b/conf-tmpl/login_athena.conf @@ -51,10 +51,7 @@ ladminallowip: all console: off // Are login's case sensitive (SQL only)? -// WARNING: Note that turning this on will cause login queries to use BINARY -// searches, which disable the table's index and cause severe performance -// penalties on large tables. -case_sensitive: off +case_sensitive: on // Gamemaster password, used with the @gm command to obtain GM commands (level of gm set with level_new_gm parameter). // NOTICE: You should also change this one. -- cgit v1.2.3-70-g09d2