Re: [sqlite] Hung query question

On Fri, 18 Nov 2016 19:20:06 + David Raymond wrote: > I've got a query that I've tried a few times here that seems like > it's hanging up on something and I'm wondering if it's just some > brain dead thing I'm forgetting or doing wrong. > > I've got a database with

Re: [sqlite] Hung query question

On 18 Nov 2016, at 7:20pm, David Raymond 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

Re: [sqlite] Hung query question

On 18 Nov 2016, at 7:20pm, David Raymond wrote: > insert into coordExtremes select State, min(Latitude), max(Latitude), > min(Longitude), max(Longitude) from foo.bar group by State; Create indexes on table foo for the latitude and longitude columns. CREATE INDEX