-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Simon Slavin wrote: > On 28 Nov 2009, at 3:55pm, Walter Dnes wrote: > >> ...and import worked. So it appears that the maximum csv file is probably >> around 2 gigabytes. > > That does make sense of some kind, but it indicates that someone is using > signed integers for file sizes. Signed would be about 2 gigabytes, unsigned > would give you about 4.
The file size type is off_t which turns out to be signed on most systems. Hence 2GB limit makes perfect sense. http://www.sqlite.org/src/info/92af7da36b Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAksRe8kACgkQmOOfHg372QT85gCfZzXw4ko1asuwFVbPykKLlzqj 5aYAnjreUB0bTZp9xROSIRs9VFcoWGd8 =NjW5 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

