mirror of
https://github.com/MeshCore-Beacon/beacon-server.git
synced 2026-10-20 15:41:57 +00:00
MrAlders0n
9bbf8efee5
* perf(routes): batch cross-IATA and hash route search (#216) One search fired a /routes/cross request per IATA pair (138k on 2026-10-08). Route search now takes an optional iatas list and runs a fixed number of index-backed queries. /info advertises built-in minimum client versions. * chore: bump version to 2.0.4
6 lines
234 B
SQL
6 lines
234 B
SQL
-- Copyright 2026 Beacon Contributors
|
|
-- SPDX-License-Identifier: AGPL-3.0-or-later
|
|
|
|
-- Cross-IATA route search looks routes up by member node.
|
|
CREATE INDEX CONCURRENTLY idx_known_routes_node_ids ON known_routes USING gin (node_ids);
|