[OZAPRS] Strange APRS packets

Damien Gardner Jnr vk2tdg at gmail.com
Tue Dec 27 09:28:34 EST 2011


Well, that was a fun morning!  Seems that I somehow missed all those years
ago, that PDO Prepared Statements tend to make postgres ignore the indexes,
and do a sequential table scan!  (Which is rather painful, when you consider
that the hamtrack database is about to hit 50GB!)

 

Replaced all the prepared statements with plain old normal statements, and
wow, what a difference!

 

Give it a burl now :)

 

http://hamtrack.pinegap.net/stationdump.php?stationid=42434

 

--DG

 

From: ozaprs-bounces at aprs.net.au [mailto:ozaprs-bounces at aprs.net.au] On
Behalf Of Philip Webb



Tried your site Damien, but it timed out and I did get my data from aprs.fi




 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.aprs.net.au/pipermail/ozaprs/attachments/20111227/ed3e1e42/attachment.html>


More information about the OZAPRS mailing list