What to choose for correspondence, SQLite or MySQL?

Question

MySQL

Hello!
Tell me, what is better to choose for correspondence, SQLite or MySQL?
I wanted to implement them through SQLite + small meta data on MySQL. For each correspondence, a separate database will be created, and it turns out that only participants in the correspondence, that is, 2 people, will send requests to it. And the very information to which database you need to connect to will be stored in MySQL, and the request to it will be from the user once, when he enters the correspondence.
In particular, speed is important, can I increase it in this way? Of course, everything would be easier through MySQL, but I think this option should, in theory, be better.
Thank you in advance!

Answer 1

SQLite and speed are incompatible concepts.
SQLite and concurrent usage is similar.
No point in it at all.
With the same success, you can do:
Why do you need SQLite? Where did they get that it is faster all of a sudden, and even more so in general for these purposes?
SQLite is single-file and simplified in relation to MySQL just so that it can be used as a base for, for example, some desktop software - not online and not multi-user.