We are in a similar situation. We have about 15K endpoints and we've had to set the DB maintenance schedules to delete pretty much everything after two days otherwise we start feeling a lot of lag. We have an all flash Nimble but even tried moving the VM to a local PCIe SSD for testing. Made no difference.

If that's true that their cloud hosting doesn't use SQLite I would be surprised.

Any update on this? I see it says Pending Review. We get email updates for CW Automate and those are nice to get when a new version is released.