- 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

1 files changed, 4 insertions, 0 deletions

diff --git a/sql-files/upgrade_svn8728.sql b/sql-files/upgrade_svn8728.sql
new file mode 100644
index 000000000..71558893f
--- /dev/null
+++ b/sql-files/upgrade_svn8728.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `friends` ADD INDEX ( `char_id` );

+ALTER TABLE `memo` ADD INDEX ( `char_id` );

+ALTER TABLE `char` ADD INDEX ( `name` );

+ALTER TABLE `char` ADD INDEX ( `online` );