Users are importing materials to my Neo4j db and a compact permanent id must be created for each node. I have a SerialNo node where the next number is available.
The problem is the long transaction. If I update the SerialNo node in the transaction, others users tasks hangs waiting end of my transaction.
Is it possible to execute SerialNo update independent of current transaction? One ways should be using Auto Commit transaction, but the manual warns it is not recommended in production environments for some reason. What is the problem?