As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
I am using Nuxeo rest APIs to upload images and some APIs are taking too much time on less tps (tested for 4 and 6 tps). After monitoring, I found that there is an update query for kv_transient_batchmanagercache table which is taking too much time to execute. Any suggestion on how I can minimize the execution time?
API: nuxeo/api/v1/upload/ Query: UPDATE "kv_transient_batchmanagercache" SET "long" = ?, "ttl" = ? WHERE "key" = ? AND "long" = ? Database: Postgres
This is a very simple query on a table that should be mostly empty, and with an index on the key column. It shouldn't be slow at all. Please check your database metrics for the reason.
key
[Florent Guillaume](https
