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?
