In my job I use many data tables that are transient. New weather data is received all the time and old data is purged. Most of these table are received as CSV files. The data is then loaded into MySQL tables and indexed to be used with geographic queries. Most of these tables never see [...]