lundi 6 avril 2015

Django and the limits of SQLite

I am building a small web app with django with the SQLite database and I am concerned about scaling issues. I don't expect too many users (less than 1000) and therefore not too many requests to read from the database.


However, an additional script, running separately from the app, downloads price data, and appends a new row to the database every second (timestamp, price1, price2, price3). Thus, the database will grow with approximately 86400 rows every day (432000 per week).


Given this setup and the relatively large numbers of rows that are added each day, is the SQLite database a suitable choice? Will it work when the number of rows goes into millions? Or is it the number of users/requests the limiting factor and not the number of rows?


Aucun commentaire:

Enregistrer un commentaire