Practical database size limit in asterisk?

Question

Asterisk

I plan to use the built-in asterisk DB (Asterisk 15.0.0) on a virtual machine (2 cores, 2 GB of memory) to store data about A-B numbers and then use this data in call routing.
With 5 thousand test records, there are no problems. But what will happen if the size of the database grows to 1 million records. What are the possible problems you might encounter? Is it worth it to use mysql right away?

Answer 1

Don't ask questions - use mysql if you need to work with the database. Embedded database is not recommended. Starting with *10 this is SQLite3.
PS While maintaining the relative simplicity of the database and queries to select from only one table, with the presence of indexes, there should be no problems with SQLite3 even with a relatively large number of records.

Answer 2

So far we have about 250,000 lines with CDR and about 100,000 in CEL - the flight is normal, it works fast, it does not slow down. Base 250MB.