digiKam - database SQLite or Mysql

I am new to digiKam.
I currently use the database Type: SQLite and everything works quite well. But because I manage about 120,000 photos, I also tried the Mysql-Internal recommended by digiKam, but this makes the program very unstable, it crashes very often. My system: Manjaro Linux.
My question: Can I continue to use the SQLite without hesitation, although I want to manage more than 100,000 photos or would it make sense to get the Mysql to work?