5

I want to create a database where text and images will be stored using blob. There will be about 5-6k entries and the size of the image will be around 1MB. That means 5-6GB of storage. Will my app be able to handle all that storage or it will crash? I wonder cause my phone is 16GB and it will be around 50% of phone's free storage. In case blob doesn't work is there an other method I can use?

Improve this question

1 Answer 1

Reset to default
8

SQLite itself will handle that much data just fine. (Databases can have up to 140 TB.)

It might be more efficient to store large images in files instead; see Internal Versus External BLOBs in SQLite. However, mobile devices behave differently; you'd have to measure it to find out which is faster.

Regardless of how you store the data, as long as you still have free space, you still can store data.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.