[sqlite] Merging two tables

2007-09-04 Thread Scott Derrick
Whats the procedure and rules for merging two tables? I have table #1, with a possible 86 thousand entries a day. an embedded application is storing sensor data. I have table #2, with a possible 50 entries a day. Both tables have a date/time field. Do I need duplicate columns in both

Re: [sqlite] Merging to tables

2005-06-18 Thread Eric Bohlman
Rasmus Christian Kaae wrote: I was wondering if there was some way of merging to tables *fast* for querying? I have the following schemas: CREATE TABLE a (term text, location blob); CREATE TABLE b (term text, location blob); What I would like to do is to iterate through *all* records in a and

[sqlite] Merging to tables

2005-06-18 Thread Rasmus Christian Kaae
Hello, I was wondering if there was some way of merging to tables *fast* for querying? I have the following schemas: CREATE TABLE a (term text, location blob); CREATE TABLE b (term text, location blob); What I would like to do is to iterate through *all* records in a and b sorted by term