diff options
| author | Matthew <pugmatt@gmail.com> | 2021-01-18 17:03:02 -0500 |
|---|---|---|
| committer | Matthew <pugmatt@gmail.com> | 2021-01-18 17:03:02 -0500 |
| commit | 3038e62a4ed79372b13b83a2164137abb38216c1 (patch) | |
| tree | 1ce63177a844960ddcfdcec8df674997121542a0 | |
| parent | 2ab7de2781d5926466b9392e85dfc100e3427879 (diff) | |
| download | BedrockConnect-1.6.2.tar.gz BedrockConnect-1.6.2.tar.bz2 BedrockConnect-1.6.2.zip | |
Add SQL index to uuid1.6.2
I don't know why I didn't think of this before, but this made the server about 300 times faster.
| -rw-r--r-- | serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java b/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java index 05f2be7..e6bcb37 100644 --- a/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java +++ b/serverlist-server/src/main/com/pyratron/pugmatt/bedrockconnect/sql/Data.java @@ -42,7 +42,9 @@ public class Data { + " uuid TEXT," + " name TEXT," + " servers TEXT," - + " serverLimit INTEGER)"; + + " serverLimit INTEGER," + + " INDEX (uuid(255))" + + ");"; Statement stmt = BedrockConnect.connection.createStatement(); stmt.execute(sqlCreate); |