Thanks for your comment Miguel!

You raised a very interesting scenario: heavy multimedia files to view offline.

In that case you should store the file content in the device file system instead of the device database, since the database is optimized to handle smaller chunks of data. The device database will still hold metadata information on those files, but the content will be in the file system.