I'm having a problem when executing deletion processes of V classes
(vertices) via HTTP Resquest through the command:
'{
"command": "DELETE VERTEX EnderecoUnico WHERE @rid=:ridEnderecoUnico",
"parameters": {
"ridEnderecoUnico": "#':NullToEmpty(LnkIn.ridEnderecoUnico):'"
}
}'
About 5.000 records to be deleted in one vertex, many of these records
start to fail with the following error message: "Read time out" and access
to orientdstudio is blocked because of this processing in progress.
I already tried to execute the delete commands with the options "LIMIT" and
"BATCH" without success
'{
"command": "DELETE VERTEX EnderecoUnico WHERE @rid=:ridEnderecoUnico
LIMIT 100",
"parameters": {
"ridEnderecoUnico": "#':NullToEmpty(LnkIn.ridEnderecoUnico):'"
}
And
'{
"command": "DELETE VERTEX EnderecoUnico WHERE @rid=:ridEnderecoUnico
BATCH 10",
"parameters": {
"ridEnderecoUnico": "#':NullToEmpty(LnkIn.ridEnderecoUnico):'"
}
}'
It still take a very long time.
Do you know how can I solve the performance issue?
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/orient-database/19ebfd6f-290d-4d2b-8d21-3bb1670cb2cdn%40googlegroups.com.
