RELEASE_NOTE.md

   1 ## Uguu 1.8.6
   2
   3 ### Whats new
   4
   5 * Includes INDEX creation in the dbSchemas files, this greatly improves performance when performing filename generation, antidupe, blacklist or rate-limit checks against the database,
   6   especially on big databases. It's recommended you follow the instructions below on how to add INDEX.
   7 * time() is called once in connector to get a timestamp instead of multiple times.
   8 * The function `diverseArray` is now called `transposeArray`, the variables within the function are also renamed to make it easier to understand.
   9 * The function `uploadFile` performs a check if `BENCHMARK_MODE` is set in the configuration, if it is the file will not be uploaded.
  10 * Benchmarking capbility added.
  11 * Docs updated with how to use [Benchmarking](https://github.com/nokonoko/Uguu/wiki/Benchmarking) and also a [Optimization Guide](https://github.com/nokonoko/Uguu/wiki/Optimization).
  12
  13 ### Breaking changes
  14
  15 * config.json must include the `"BENCHMARK_MODE"` value, should be set to `false` when not benchmarking, otherwise file(s) will not be uploaded.
  16
  17 ### Add INDEX to an existing Uguu installation
  18
  19 #### SQLite
  20
  21 ```
  22 CREATE INDEX files_hash_idx ON files (hash);
  23 CREATE INDEX files_name_idx ON files (filename);
  24 CREATE INDEX ratelimit_iphash_idx ON ratelimit (iphash);
  25 CREATE INDEX blacklist_hash_idx ON blacklist (hash);
  26 ```
  27
  28 #### PostgreSQL
  29
  30 ```
  31 CREATE INDEX files_hash_idx ON files (hash);
  32 CREATE INDEX files_name_idx ON files (filename);
  33 CREATE INDEX ratelimit_iphash_idx ON ratelimit (iphash);
  34 CREATE INDEX blacklist_hash_idx ON blacklist (hash);
  35 ```
  36
  37 #### MySQL
  38
  39 ```
  40 CREATE INDEX files_hash_idx ON files (hash);
  41 CREATE INDEX files_name_idx ON files (filename);
  42 CREATE INDEX ratelimit_iphash_idx ON ratelimit (iphash);
  43 CREATE INDEX blacklist_hash_idx ON blacklist (hash);
  44 ```