Daily Archives: April 13, 2008

Optimize this?

Posted on April 13, 2008 by Paul Tomblin

The main loop query of my waypoint generator app is kind of hairy. And trying to do an “explain” on a typical query shows why it’s so slow. explain SELECT a.id, c.pdb_id, internalid, a.type, name, address, state, country, latitude, longitude, … Continue reading →

Posted in Flying, Geekery, Revelation | 2 Comments

We’ll just consider that drawing board “backed”, shall we?

Posted on April 13, 2008 by Paul Tomblin

Ok, I just added some indexes, and now the PostGIS version runs in 45 seconds. Phew! Man, I love “-d:DProf”.

Posted in Flying, Geekery, Revelation | Comments Off

Back to the drawing board

Posted on April 13, 2008 by Paul Tomblin

In order to support a new product development I mentioned in an earlier blog post, I re-did my existing waypoint database as a PostGIS geographical database. I also added some foreign keys and some other cleanup that I’ve been meaning … Continue reading →

Posted in Flying, Geekery, Rant | 1 Comment