SQLite size limit and performance
SQLite is suitable for storing data locally in user's Machine. 

On Database size limit, maximum database size of 140 terabytes.

On reading data SQLite support index so you can think of having indexes based on your select query.

you can read more about it from below link:

https://www.sqlite.org/limits.html 

https://www.tutorialspoint.com/sqlite/sqlite_indexes.htm