Re: [sqlite] RTrees and query speed

2013-12-09 Thread skywind mailing lists
Am 09.12.2013 um 10:06 schrieb Clemens Ladisch : > skywind mailing lists wrote: >> Assume I have the following tables: >> >> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); >> CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, >> FromLongitude,TillLongit

Re: [sqlite] RTrees and query speed

2013-12-09 Thread Clemens Ladisch
skywind mailing lists wrote: > Assume I have the following tables: > > CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); > CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, > FromLongitude,TillLongitude); > > According to the RTree documentation this query s

Re: [sqlite] RTrees and query speed

2013-12-08 Thread Keith Medcalf
>> SELECT COUNT(*) FROM A,B > >Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before. Yes. It is part of the SQL language definition since before there was an SQL language definition. "," means "JOIN" or more pedantically "INNER JOIN". "ON" means "WHERE". The only circumstance

Re: [sqlite] RTrees and query speed

2013-12-08 Thread Simon Slavin
On 8 Dec 2013, at 11:03pm, skywind mailing lists wrote: > SELECT COUNT(*) FROM A,B Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

[sqlite] RTrees and query speed

2013-12-08 Thread skywind mailing lists
Assume I have the following tables: CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, FromLongitude,TillLongitude); and there is an index on A for Latitude,Longitude. B is filled using INSERT INTO B SELECT