Solution for slow imports taking up to 4 minutes per transaction (Unraid)

[mb55177]

After recently starting to use Firefly III I was having incredibly slow imports, up to 4 minutes per transaction.
To note, I am using the Unraid docker container to host Firefly 3, along with the Unraid docker container for the data importer.
After lots of searching and research I was able to find a solution which has resulted in 1-2s per transaction for an import.

I added/changed the following lines in the custom.cnf file:
innodb_buffer_pool_size=2G
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
max_connections=200

Not sure if this is the fault of the Unraid docker, or how Firefly III is configured out of the box.
The discussion below clued me onto the fix, along with ChatGPT consultation to make sure I wasn't breaking anything
https://github.com/orgs/firefly-iii/discussions/11805