History and other components is very slow

Hello,

I have a problem of slowness with the history as well as with some components such as vscode, configurator, etc.

I use hass.io installed on a virtual machine under ubuntu 19.04, a storage space of 72GB and 2GB ram.

I have mqtt to install which goes up from a transmitter the electricity consumption of my linky meter (I live in France) so very talkative. I also have a mini weather station which goes up to me every 5 minutes 3 values.

do you think that by switching from the sqlite database to mariadb it will improve things, besides how to do with a docker environment, I didn’t quite understand how to do the migration, even using the article

Migrating home assistant database from sqlite to mariadb

thank you to the people who will take the time to clarify things for me

chris