We are using yugabyte database with YCQL driver(gocql) We have below two queries: selectQueryMessage= "Select col2, col3, col4, col5 from table1 " + "WHERE primarykeyCol = ?" insertQueryMessage = "INSERT INTO table1 (primarykeyCol, col2, col3, col4, col5) VALUES (?, ?, ?, ?, ?) " + "IF NOT EX…

[image] sham_yuga: So that means, from the performance perspective, it is not a good idea to have referential integrity constraints across tables It is slower on INSERT because the db will check the row exists on the other table (the same with DELETE). But not on SELECT.

Why INSERT query is slower than SELECT query?

General

dorian_yugabyte January 22, 2022, 4:44pm 15

It is slower on INSERT because the db will check the row exists on the other table (the same with DELETE).

But not on SELECT.

Topic		Replies	Views
Ysql high latency General	5	46	April 7, 2025
Yugabytedb select so slow Design Discussions	6	889	July 9, 2021
Slow insert performance on single-node setup? General	1	29	May 5, 2025
Query performance on table with indices General	10	1341	March 18, 2022
Which one has better write performance between YugabyteDB cluster and single node General	5	993	March 13, 2023

Why INSERT query is slower than SELECT query?

Related topics