Re: [sqlite] Merging N databases

2008-10-12 Thread ferrety ferrety
Hi Kishor and Igor, Thanks very much. I'll test that and come back with first impression on speed. Regards Ferret On Fri, Oct 10, 2008 at 9:48 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > ferrety ferrety <[EMAIL PROTECTED]> > wrote: >> Let me give you how the DBs looks like in a real example.

Re: [sqlite] Merging N databases

2008-10-10 Thread Igor Tandetnik
ferrety ferrety <[EMAIL PROTECTED]> wrote: > Let me give you how the DBs looks like in a real example. > Each DB contains a uniq table called URL : > > CREATE TABLE if not exists URL (name VARCHAR PRIMARY KEY, nbr > INTEGER); > > $ sqlite3 /tmp/links1.db : > sqlite> select * from URL; > www.foo.com

Re: [sqlite] Merging N databases

2008-10-10 Thread P Kishor
On 10/10/08, ferrety ferrety <[EMAIL PROTECTED]> wrote: > Hi, > > I'm new to SQLite and to list !!! So ... > > I've "N" sqlite DBs all produced with the same version of SQLite3 and > all having the same DB schema (only 1 table). > I'd like to merge them all in one single DB. The merge process n

[sqlite] Merging N databases

2008-10-10 Thread ferrety ferrety
Hi, I'm new to SQLite and to list !!! So ... I've "N" sqlite DBs all produced with the same version of SQLite3 and all having the same DB schema (only 1 table). I'd like to merge them all in one single DB. The merge process needs to be done as fast as possible. Let me give you how the DBs looks