Re: [sqlite] planning to use sqlite for a project involving huge data

Hi Jay, Thanks for your reply. I don't think I can use the attach statement. I thot attach statement can combine different databases, but not on a database with a single table. I think at best it could split a large db file by splitting the tables within the database (if there are multiple

Re: [sqlite] planning to use sqlite for a project involving huge data

On 5/2/06, E Tse <[EMAIL PROTECTED]> wrote: I wish sqlite can be enhanced to represent itself as a collection of files, See the database 'attach' statement http://sqlite.org/lang_attach.html .

Re: [sqlite] planning to use sqlite for a project involving huge data

Wednesday, May 3, 2006, 06:42:34, E Tse wrote: > I am planing to use sqlite for a project involving huge data. The planned > sqlite file (which will contain a single table) will grow to more than 4g in > size. Has anyone try that before and what problems have you encountered? Be prepared, that

Re: [sqlite] planning to use sqlite for a project involving huge data

On May 2, 2006 09:42 pm, E Tse wrote: > Hi all, > I am planing to use sqlite for a project involving huge data. The > planned sqlite file (which will contain a single table) will grow to > more than 4g in size. Has anyone try that before and what problems > have you encountered? Some operating

[sqlite] planning to use sqlite for a project involving huge data

Hi all, I am planing to use sqlite for a project involving huge data. The planned sqlite file (which will contain a single table) will grow to more than 4g in size. Has anyone try that before and what problems have you encountered? I heard that the initial disk caching time might be a problem,