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
Félix Baylac-Jacqué