Database Schema (cont.)

• There are tables “lastposition”, “lastweather”, “laststatus” that contain only the latest information from a station.

  • Use these!
  • Very fast to retrieve from. A single station lookup in < 0.01 seconds.
  • Queries can be done even on non-indexed columns because tables get cached into memory.

Notes: