Recently i come across to have 20000+ data pending to forward to the database because I disabled the database for maintenance. The forward 20000+ of data back to the database is like taking forever. I tried to change the block size to be larger (100) and the write time to be shorter (100ms) but it doesn’t speed up the process. Any way to speed up the forwarding speed?
Thank you.
This might be a little after the fact, but you could try increasing the size of the connection pool for the database connection. Gateway > Configure tab > Database connections > edit your database connection > Connection Pooling.
The Max Active and Max Idle properties default to 8. Assuming the database server is healthy (i.e. not maxing out the CPU on the server) you could try doubling that to 16 for each.