Thanks for that insight which explains a lot.
I would be very happy to try DBD::MariaDB (of which I was unaware until you wrote so thanks again) but I'm not sure if it's compatible with Rose::DB::Object or indeed how to configure Rose to use it. Does anyone know?