Only one thread.

A test below took 1.2 second to do 10 insert, at around 120ms per insert. If the expect insert time is 2x network latency, my insert should be less than 10ms each.

CREATE TABLE if not exists FILU.T_Test_Phone (

phone INT NOT NULL,

carrierid int not null,

firstseen TIMESTAMP WITH TIME ZONE NOT NULL,

lastmodified TIMESTAMP WITH TIME ZONE NOT NULL,

CONSTRAINT “primary” PRIMARY KEY (phone ASC),

FAMILY “primary” (phone, carrierid, firstseen, lastmodified)

);

SET TIME ZONE ‘America/New_York’;

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111151111, 6, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,6), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111161111, 56, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,56), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111171111, 56, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,56), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111181111, 26, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,26), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111191111, 66, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,66), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111112111, 66, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,66), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111113111, 26, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,26), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111114111, 66, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,66), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111115111, 6, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,6), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);

Insert into FILU.T_Test_Phone (Phone,CarrierID, FirstSeen, LastModified) values (1111116111, 24216, ‘2017-07-26 00:07:25’, ‘2017-07-26 00:07:25’) ON CONFLICT(Phone) do update set CarrierID = if(T_Test_Phone.LastModified > ‘2017-07-26 00:07:25’,T_Test_Phone.CarrierID,24216), LastModified = if(T_Test_Phone.LastModified>‘2017-07-26 00:07:25’, T_Test_Phone.LastModified, ‘2017-07-26 00:07:25’);