Ask HN: How much data can a 5MB database store?
How much data can a 5MB database store?
3 comments
The Bible, in two different translations, as an MySQL file (though I don't know how optimized it is), with Fulltext Indexes, is 10 mb[1].
So one Bible is ~5.
Does that help?
-------------
[1] http://www.biblesql.net/download
So one Bible is ~5.
Does that help?
-------------
[1] http://www.biblesql.net/download
Umm... 5MB minus database overhead?
That was going to my answer, too, so I'll elaborate a bit.
It depends on the format of the database and the contents as well. If all you store is a single 4.9MB image, then there's not much overhead. If you store thousands of short text records, then each one can only have a little data, and will have a lot of overhead.
It depends on the format of the database and the contents as well. If all you store is a single 4.9MB image, then there's not much overhead. If you store thousands of short text records, then each one can only have a little data, and will have a lot of overhead.
5mb compressed minus database overhead?
About 5MB