On 18 Nov 2016, at 7:20pm, David Raymond <david.raym...@tomtom.com> wrote:
> insert into coordExtremes select State, min(Latitude), max(Latitude), > min(Longitude), max(Longitude) from foo.bar group by State; Apologies. Correction to my earlier post: Create indexes on table foo for the State, latitude and longitude columns. CREATE INDEX idx_foo_lat ON foo (State, Latitude); CREATE INDEX idx_foo_long ON foo (State, Longitude); ANALYZE; Then try the SELECT again. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users