Re: [sqlite] bigfile test

2007-08-22 Thread J Jayavasanthan
More on to my earlier email, I believe SQLite already uses those flags, I haven't done the testing myself, but it is claimed SQLite is able to create rather large databases (in terms of TBs) without any fuss, Regards, Jayavasanthan J On 8/22/07, J Jayavasanthan <[EMAIL PROTECTED]> wrote: > > Hi

Re: [sqlite] bigfile test

2007-08-22 Thread J Jayavasanthan
Hi Victor, Normally the large file creation should not fail on the 32 bit builds. And -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 will create other side effects such as off_t getting to long long rather than long and similar with size_t (I guess). The solution is to access/create the file along wi

[sqlite] bigfile test

2007-08-21 Thread Victor Secarin
Having built sqlite 3.4.2 for Enterprise 3, 4, Fedora 5 and Solaris 8, both 32 and 64 bits, I then ran the fulltest on each. As it takes a long time and produces a large output, one looks first at the end, and if it says "0 errors" one thinks everything is as expected. By chance, I later disco