Hi Michael, I agree -- while in theory it shouldn't be difficult, the testing and verification would be painful! And it's unclear to me from glancing through the code how locking should be handled -- probably just on the first data file.
I saw some historic posts on here where people were discussing writing just such a layer, thought there might be something reusable :-) I will work on bringing the customer into the 20th century instead. Thanks! - James > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Black, Michael (IS) > Sent: Monday, July 19, 2010 12:42 PM > To: j...@kreibi.ch; General Discussion of SQLite Database; General > Discussion of SQLite Database > Subject: Re: [sqlite] VFS Layer for to split databaseinto several > files? > > Oops -- my bad...I guess I never ran into that problem in the "old" > days. I know I used to write 2Gig+ files on 32-bit Linux before it was > popular. > > So...perhaps the next logical question is...can this guy's user put > NFSV3 or such on? Would be a lot easier than writing your own split- > VFS which I think is asking for trouble. > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Northrop Grumman Information Systems > > > ________________________________ > > From: sqlite-users-boun...@sqlite.org on behalf of Jay A. Kreibich > Sent: Mon 7/19/2010 2:29 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] EXTERNAL:Re: VFS Layer for to split databaseinto > 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
