Possible regression in UNWIND performance with **old** gremlin Cypher engine (13 seconds to create one relation)

[ExtReMLapin]

While waiting for fixes on new cypher "engine", I moved back to old one.

Trying to execute this query :

UNWIND $batch as row
MATCH (a),(b) WHERE ID(a) = row.source_id and ID(b) = row.target_id 
MERGE (a)-[r:in]->(b)RETURN a, b, r

With a batch size of ~700 it was taking ages, so in the debugger, i tried with only one entry and jesus ... it took 13 seconds to create one relation.
I restarted my arcadedb multiple times, issues happens again and again on OLD cypher engine

micro batch size entry :

{"batch": [{"source_id": "#10:0", "target_id": "#1:3", "features": {}, "relation_type": "in"}]}

chrome_FJuNOEDqBz.mp4

database dump :

SDJFKLSDJFKLS-backup-20260115-160216620.zip

[ExtReMLapin]

Even with no params, full text query is slow as hell

UNWIND [{source_id: "#10:0", target_id: "#1:3", features: {}, relation_type: "in"}] as row
MATCH (a),(b) WHERE ID(a) = row.source_id and ID(b) = row.target_id 
MERGE (a)-[r:in]->(b) RETURN a, b, r

But

MATCH (a),(b) WHERE ID(a) = "#10:0" and ID(b) = "#1:3" 
MERGE (a)-[r:in]->(b) RETURN a, b, r

Takes only 36ms to execute

[lvca]

What part is a full text query? Is 36ms with the new or old engine?

[ExtReMLapin]

By full text query i meant "no param" query.

UNWIND [{source_id: "#10:0", target_id: "#1:3", features: {}, relation_type: "in"}] as row
MATCH (a),(b) WHERE ID(a) = row.source_id and ID(b) = row.target_id 
MERGE (a)-[r:in]->(b) RETURN a, b, r

All queries are ran on old engine, 36 ms is old engine

[ExtReMLapin]

Also , what the fuck, query posted above works but is slow, and when removing unused params, i get com.arcadedb.exception.CommandExecutionException

UNWIND [{source_id: "#10:0", target_id: "#1:3"] as row
MATCH (a),(b) WHERE ID(a) = row.source_id and ID(b) = row.target_id 
MERGE (a)-[r:in]->(b) RETURN a, b, r

[lvca]

Stil with the old engine? or the new one?

[ExtReMLapin]

always old engine, no new engine used in this issue

[ExtReMLapin]

Yeah whatever nevermind, forget the failing query, i forgot a } not feeling very smart right now.

[lvca]

Working on fixing the UNWIND/MATCH/MERGE with the new engine, it should always be much faster

[ExtReMLapin]

I understand, i fear that the regression can still be an issue on the old engine tho

13 seconds to create one relation, eek

[lvca]

Please check the latest main branch with the fix on UNWIND/MATCH/MERGE ;-)

[ExtReMLapin]

I just left the office, will check tomorrow 👍🏻

[lvca]

Closing this issue, the old engine will not be supported anymore for fixes. Use the new Cypher ;-)