One common cause of poor query performance is running numerous Cypher statements with literal values.

This results in inefficient execution because parameters are not used, preventing full utilization of the execution plan cache.
Using parameters can significantly enhance query performance by allowing for more effective caching and reuse of execution plans.

If you issue 10 cypher queries identical in form but with different literals, you will not get the most optimal cache and reuse of memory and will instead incur multiple times parsing and generating an execution plan.  

For example, consider the below query:

match (tg:asset)  where tg.name = "ABC123"
merge (tg)<-[:TAG_OF]-(z1:tag{name:"/DATA01/"+tg.name+"/Top_DOOR"})
merge (tg)<-[:TAG_OF]-(z2:tag{name:"/DATA01"+tg.name+"/Data_Vault"})
. . . 

The above query can be rewritten as follows:

MATCH (tg:asset) WHERE tg.name = $gtName
WITH tg
UNWIND $tags as tag
MERGE (tg)<-[:TAG_OF]-(:tag {name: tag.name})