Originally from the User Slack
@Celal: Hello
is here any way to do do something like
const res = await scylladb.execute("UPDATE val SET x = x + 1");
const newX = res.get("x")
without lightweight transactions and needing to do another operation with “SELECT x FROM val…”?
@avi: No, you will need to SELECT after an update
@Celal: Is there any wisdom behind it? Or is it just not implemented
If there would be an option to retrieve the value right after an option, it would speed up my API x1.5 overall
and one specific part even x100 throughput wise since i can then leave out the LWT
@avi: We’re following CQL/SQL, and it’s not how the API flows