It's great that you're aware of the problem in time, especially before trying to go live.
Based on one of my recent articles, I can advise you on an excellent configuration to solve the bottleneck problem.
As you've already noticed, the process between the processor, motherboard, SSD, and HDD isn't direct. This means that valuable milliseconds are lost during processing, along with some data loss during the return process.
If you want CPU perfection, apply this example:
Motherboard: AM5 - DDR5
Processor: (in my case) AM5 Ryzen - 16 cores, 32 threads
RAM: AM5 - DDR5
Storage: NVMe (directly on the motherboard)
No SSD or HDD. Everything must be fully compatible and mounted directly on the motherboard.
This way you won't have any more bottlenecks and I highly doubt you'll lose information or misconfigure the system again during the process return.