cloudlog/application/config
Peter Goodhall e904595a9d Lazy-load QSO lists; add time index migration
Bump migration version to 265 and add a migration (265_add_station_time_on_index) that creates idx_station_time_on on (station_id, COL_TIME_ON) for faster time-based queries. Introduce lazy QSO loading: controller now sets defer_qso_list and uses a new POST endpoint get_filtered_qsos to fetch filtered QSO lists and summaries; also updated cache keys/render version and added per-entry cache deletion. Note model: add include_qso_list flag, memoize QSO summaries/lists and station IDs, replace DATE(COL_TIME_ON) filters with half-open datetime ranges (start inclusive, end exclusive) via helper methods to improve index use and performance. View: update public_index to render QSO list containers with data attributes, add JS to fetch and render QSO rows on demand, and support highlight DX updates. Overall changes optimize QSO queries and enable deferred loading to reduce initial page load and DB cost.
2026-04-06 11:11:03 +01:00
..
autoload.php autoload user_options_model 2023-12-03 17:52:26 +01:00
bands.php Addition of 33cm and 1.25m bands where appropriate, reclassification of some bands as Microwave rather than UHF 2022-01-20 21:10:16 -07:00
cloudlog.php Add public Station Diary with images & RSS 2026-03-08 11:42:41 +00:00
cloudlog_data_lists.php Create cloudlog_data_lists.php 2019-06-29 15:51:39 +01:00
config.sample.php Add Portuguese language support to config 2025-08-27 10:44:42 +01:00
constants.php Enforce unique callsigns and protect last admin 2026-03-26 14:22:02 +00:00
database.sample.php Cleanup SQL CHARSET and COLLATE 2022-01-25 08:28:37 +01:00
doctypes.php Added Basic Files 2011-04-25 16:24:01 +01:00
foreign_chars.php Added Basic Files 2011-04-25 16:24:01 +01:00
hooks.php Added Basic Files 2011-04-25 16:24:01 +01:00
index.html Added Basic Files 2011-04-25 16:24:01 +01:00
lotw.php Use LoTW as official abbreviation 2023-07-27 09:16:55 +02:00
migration.php Lazy-load QSO lists; add time index migration 2026-04-06 11:11:03 +01:00
mimes.php Merge pull request #1772 from agrif/p12-file-type 2022-11-12 14:33:30 +00:00
profiler.php Added Basic Files 2011-04-25 16:24:01 +01:00
routes.php Add reactions to station diary entries 2026-03-09 13:29:14 +00:00
smileys.php Added Basic Files 2011-04-25 16:24:01 +01:00
user_agents.php Added Basic Files 2011-04-25 16:24:01 +01:00