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
