[sqlite] Poor performance searching from multiple DBs

Hello, I have this Database: CREATE TABLE other( field1 VARCHAR(15), field2 VARCHAR(2), field3 VARCHAR(255), field4 VARCHAR(255)); CREATE TABLE main ( field1 VARCHAR(15), field5 VARCHAR(8), field2 VARCHAR(2), field6 VARCHAR(2), INS_82 VARCHAR(2), field7 VARCHAR(255)); CREATE TABLE

Re: [sqlite] Merging to tables

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

Re: [sqlite] Page size

On Fri, 2005-06-17 at 22:54 -0400, Joel Lucsy wrote: > I was investigating if file mapping could be used under win32, but > have run into a roadblock. The win32 documentation for MapViewOfFile > (which is the part that maps the drive data into memory) wants the > file offset to be a multiple of

[sqlite] Merging to tables

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

Re: [sqlite] errors compiling with MS VC++ 6.0

[18-06-2005 0:54, Randall Fox escreveu] When I then try to build the project, I get internal compiler errors. Here are the first few lines of 35 errors it has: I have built v3.08 and v2.x using VC++ 6 and 7.x You do get a lot of casting warnings (which you can turn off/ignore), but I never