summaryrefslogtreecommitdiff
path: root/conf-tmpl/login_athena.conf
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-13 01:07:45 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-09-13 01:07:45 +0000
commit6ce3e3bc0de4fe7faf2c7bed6e0b2d234b241f12 (patch)
tree9a9982616eb55cbcc353207521c370d0c1dad16b /conf-tmpl/login_athena.conf
parentef2ebfc6da2dac054af7dfe206bf1ea9906435ea (diff)
downloadhercules-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 'conf-tmpl/login_athena.conf')
-rw-r--r--conf-tmpl/login_athena.conf5
1 files changed, 1 insertions, 4 deletions
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.