Thanks a lot Stephen. I guess I have to do this on parts of the input file at a time then, which I will try, though it will be an approximation of the file I am trying to implement, but that is fine. What would be the limit of the file size that sqlite can create, assuming disc space is not an issue.
-Abhisek On Mon, Jul 18, 2011 at 11:01 AM, Stephan Beal <[email protected]>wrote: > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
