What "modern" system doesn't support NFSV3? They might have that turned on by default for their file export to legacy systems perhaps. The two systems should default to the highest version supported by both so who's holding the show? Are you running your application on another Linux box? Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of James Croall Sent: Mon 7/19/2010 2:42 PM To: j...@kreibi.ch; 'General Discussion of SQLite Database' Subject: Re: [sqlite] EXTERNAL:Re: VFS Layer for to split database into several files? Hi All, This is a very modern Linux64 system and the only limiting factor I can find here is the NFSv2 filesystem. Our process gets killed with a SIGXFSZ when we exceed 2GB. The user is not keen on changing their environment to support my application. Looking through os_unix.c it looks like it could be reasonably easy to turn one db file into, say, a series of four each with a maximum size of 2GB, and decide which fd to use based on the offset requested. Plus enough logic to keep pages in the same partition. Thanks, - James > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Jay A. Kreibich > Sent: Monday, July 19, 2010 12:30 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] EXTERNAL:Re: VFS Layer for to split database into > several files? > > On Mon, Jul 19, 2010 at 01:48:56PM -0500, Black, Michael (IS) scratched > on the wall: > > NFSV2 is something that limits filesize. > > From the phrasing of the rest of your email, I assume you meant for > this to be "NFSv2 *isn't* something...". > > And technically that is true. NFS won't limit the filesize. > > However, NFSv2 has a very well known limitation, in that network > clients could only access the first 2GB worth of a file. That > effectively limits the usable filesize to 2GB. > > http://en.wikipedia.org/wiki/Network_File_System_%28protocol%29#NFSv2 > > There are still many systems (especially embedded ones) out there > that only support NFSv2. Like TFTP, it is a dead simple protocol > that requires almost no state, a very simple networking stack, > and is very easy to cram into a very limited code space > > -j > > > > > Generally what limits filesize is the operating system and associated > > compilation flags like Pavel mentioned. > > > > What makes you or your "user" think their system is limited to 2GB? > > What OS are they using and what OS are you using? If it's anything > > more recent than about 10 years ago it should support >2GB as long as > > you have the disk space. > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
