Hybrid drive for QNAP? Or really need SSD?

I understand why an SSD is recommended for the Roon database. But what about hybrid drives that have an SSD cache and the rest of the storage is a spinning disk?

Hybrid drives only have a small amount of SSD on them and there’s no guarantee that the database tables and indexes would utilise this, so Roon performance could be similar to using spinning disk.