Tuning PosgreSQL/Wappler query performance

Hello Wapplers,

• I have project built on NodeJS 16 + Docker + PostgreSQL 12.4
• I have table with 10000 records (dummy data for now)
• I’m running a server side workflow which goes trough each records and updates them
  
  

  image605×501 38.7 KB
• It takes ~105 second in average to run this job
• During this job I’m monitoring PosgteSQL dashboard and there is maximum 200 transactions per second in average
  
  

  Capture2112×514 68.5 KB

My task is to lower the execution time for this workfow.
What I’ve tried far:

• Customizing PostgreSQL config file with
  I found on-line tool config generation tool https://www.pgconfig.org/ and applied it with Docker command. After I checked the config from PostgreSQL itself SHOW all; I ran task again and got same 105 seconds and maximum 200 transactions per second in average
• Running this task under Wappler parallel
  
  

  image833×606 42.1 KB
  
  I’m getting ~125 seconds and 160 transactions per second in average
  What’s Wappler is actually paralleling?

So my question to all Wappler enthusiasts - what would you else suggest to decrease execution time of this workflow?

Thank you reading.