Do you know how can I solve the performance issue?
Em quinta-feira, 2 de fevereiro de 2023 às 10:49:56 UTC-3, Eduardo Lima
escreveu:
> 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/bd0255ef-fe95-4b31-8b51-58eee5b26b2dn%40googlegroups.com.
