I’m using cockroach db with nakama!
I have only one server, and I don’t need replication enabled!
Querys that took in the begin around 2 ms, after so time using the db…
Log Table with 9Gb
Storage Table with 1.5Gb
I get around 500ms…
The storage table have a replication of 5, now I have recreated the db and put only 1.
I have done this tweaks:
ALTER RANGE default CONFIGURE ZONE USING gc.ttlseconds = 1;
SET CLUSTER SETTING kv.range.backpressure_range_size_multiplier=0;
SET CLUSTER SETTING diagnostics.reporting.enabled = false;
I can do something better ? To improve the performance, completely disable replication ?