im currently testing the UPSERT Statement.
- 4 Servers each 32 Cores, 128 GB ram, 2 SSDs
- Each Server has one CockroachDB Instance with 2 Stores
- 200 sequential Transactions
- Each Transaction on average 330 words
- 23755 different words
CREATE TABLE words (
word STRING(255) NOT NULL,
frequency INT NULL,
CONSTRAINT “primary” PRIMARY KEY (word ASC),
FAMILY “primary” (word, frequency)
UPSERT INTO words (word, frequency) VALUES(?, ?);
RELEASE SAVEPOINT cockroach_restart;
I have writen a Java App for this test. Executing all 200 Transaction takes over 5 minutes. I think this is very slow. Is there something wrong with my app or are this normal values for cockroach?