I already studied some databases like MySQL but I never professionally work with databases. I am working on a project and we intend to use SQLite (for some reasons: small, lightweight, fast, among others), then I have some questions about it:

  1. SQLite support how many gigabytes of data? Is there a limit? (I will have some huge data tables (e.g. 18 columns X 80.000 rows) for each user)

  2. Is it fast to read a lot of data? (e.g. 18 columns X 80.000 rows)

  3. There is any other relevant information I need to know about SQLite? (Note: I will use it on Windows and OS X)

Extra information:

The software I am working on is a data analysis software, and I just need to use the DB to save the data collected from the users using some sensors.

I am using Qt 5.3.2 (C++) on the project.

  • I didn't understand how you are going to get to Gigabytes Dec 2, 2016 at 14:17
  • I'm not saying I'm going to get to Gigabytes, I'm just asking if it is possible, if there's a "size" limit.
    – KelvinS
    Dec 2, 2016 at 14:21
  • P.s. 80K rows is a very small set. Processing it would take fractions of a second. Dec 2, 2016 at 14:34
  • Great, this is a good thing. Thanks Dudu Markovitz.
    – KelvinS
    Dec 2, 2016 at 15:13

1 Answer 1


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:



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.