Nuxeo DB queries are taking too much time to execute.

I am running performance tests on Nuxeo starting from 2 TPS and I am getting the below queries which are taking too much time to execute. Also, they are getting executed multiple times per transaction of upload API.

1st Query: UPDATE “kv_transient_batchmanagercache” SET “long” = $1, “ttl” = $2 WHERE “key” = $3 AND “long” = $4

2nd Query: SELECT DISTINCT “hierarchy”.“id” AS “C1” FROM “hierarchy” LEFT JOIN “dms” “F1” ON “hierarchy”.“id” = “F1”.“id” LEFT JOIN “dublincore” “F2” ON “hierarchy”.“id” = “F2”.“id” LEFT JOIN “dms_proof_type” “F3” ON “hierarchy”.“id” = “F3”.“id” LEFT JOIN “versions” “F4” ON “hierarchy”.“id” = “F4”.“id” WHERE ((“hierarchy”.“primarytype” IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49)) AND (“F1”.“case_id” = $50) AND ((“hierarchy”.“istrashed” = $59 OR “hierarchy”.“istrashed” IS NULL)) AND (“F1”.“platform_identifier” = $51) AND (“F1”.“product_code” = $52) AND (“F1”.“applicant_id” = $53) AND (“F1”.“tenant_id” = $54) AND (“F1”.“proof_name” = $55) AND (“F2”.“title” = $56) AND (“F3”.“item” = $57) AND (“F4”.“versionableid” IS NULL ) AND (“_F1”.“application_role” = $58))

are these queries mandatory to execute for an upload operation? Is there any way to switch off the execution of these queries? Why they are getting called for multiple time?

0 votes

0 answers

629 views

ANSWER