On Mon, Jul 18, 2011 at 4:58 PM, [email protected]
<[email protected]>wrote:

> These are addresses accessed by a program. There will be 100 billion
> entries
>

You won't be able to fit that many in your database - sqlite3 cannot scale
to the file size you will need for that. Assuming 10-byte addresses (as you
demonstrated), 10 bytes x 100B records = 1 terrabyte JUST for the addresses
(not including any sqlite3-related overhead per record, which is probably
much larger than the 10 bytes you're saving).

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to