RE: [sqlite] Optimize performance - reading from multiple database files, processing and writing to separate results database file?

2006-10-04 Thread Tom Briggs
6 9:57 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Optimize performance - reading from > multiple database files, processing and writing to separate > results database file? > > Yes, I could indeed determine which databases I want to > attach to, but there > is a lim

Re: [sqlite] Optimize performance - reading from multiple database files, processing and writing to separate results database file?

2006-10-04 Thread Serena Lien
Yes, I could indeed determine which databases I want to attach to, but there is a limit to the number of databases you can attach (I think it's 32?) and I might have more than that. So I thought the safer route was to attach as I go.. Serena. On 10/4/06, Tom Briggs <[EMAIL PROTECTED]> wrote:

RE: [sqlite] Optimize performance - reading from multiple database files, processing and writing to separate results database file?

2006-10-04 Thread Tom Briggs
ubject: [sqlite] Optimize performance - reading from > multiple database files, processing and writing to separate > results database file? > > Hello, > > I have many databases, all in separate files. I want to > choose a subset of > them > based on some query, and

[sqlite] Optimize performance - reading from multiple database files, processing and writing to separate results database file?

2006-10-04 Thread Serena Lien
Hello, I have many databases, all in separate files. I want to choose a subset of them based on some query, and read the input data one at a time, process it somehow and write the results to another database file. The problems are caused by: - May have a large number of inputs (eg > 32