Nuxeo DB queries are taking too much time to execute.

Ankush_Bandil — Wed, 03 Feb 2021 13:35:21 GMT

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?

topic Nuxeo DB queries are taking too much time to execute. in Nuxeo Forum

Nuxeo DB queries are taking too much time to execute.