How much data can be stored in SQLite?

Question

Java

Hello, I am writing a program for android. The program will store some data in SQLite. But is there a limit to the amount of stored data and what determines it? If yes, how much can be stored?
Thank you very much in advance!

Answer 1

Not the original source, but:
https://ru.wikipedia.org/wiki/SQLite
"Maximum database page size 32,768 SQLITE_MAX_PAGE_SIZE
Maximum number of pages in a database file 1,073,741,823 SQLITE_MAX_PAGE_COUNT
Currently, only the SQLITE_MAX_PAGE_SIZE value cannot be greater than the specified By default, without changing SQLITE_MAX_PAGE_COUNT, we can say that the maximum size of a database file is approximately 32 TB (35'184'372'056'064 B)."

Answer 2

Due to common sense and the speed of SQLite, it seemed to me personally that when storing more than 10,000 simple records, speed problems begin.