Félix Baylac-Jacqué 6787e782da Add an index on the full_insee field ... This DB is mostly used to retrieve all the street names for a given city. Adding an index for the full_insee field greatly improves the query time. Without the index: time $(echo 'select * from fantoir where full_insee="65054";' | sqlite3 fantoir.sqlite) real 0m2,230s user 0m1,896s sys 0m0,337s With the index: time $(echo 'select * from fantoir where full_insee=65054;' | sqlite3 fantoir.sqlite) real 0m0,148s user 0m0,126s sys 0m0,024s		2022-02-17 22:18:23 +01:00
..
gen-fantoir.sh	Add an index on the full_insee field	2022-02-17 22:18:23 +01:00