Category Archives: databases

5MHz Propagation Forecasts utilising the Experiment’s Database

Using historical data to predict future conditions This article, written by Gwyn Williams G4FKH and published in RadCom December 2011 is © RSGB 2011, reproduced with permission. BRIEF HISTORY The RSGB 5MHz Experiment started toward the end of 2002, when the 5MHz Working Group was formed under the chairmanship of John Gould, G3WKL. The current […]

Also posted in hamradio, programming | Tagged , , , , , , , , , , , , , , , , | Comments closed

A Little SQL “EXPLAIN” example

Background: I have a big table called “channel” with a few hundred thousand rows in – nothing vast, but big enough to cause some queries to run slower than I want. Today I was fixing something else and happened to run show full processlist; I noticed this taking too long: SELECT payload FROM channel LIMIT […]

Also posted in programming | Tagged , , , | Comments closed